Physical storage and full-text metadata
operators #tsql#operators
Description
TYPE_NAME
Returns a data type name by ID.
TYPEPROPERTY
Returns a property of a data type, such as precision or nullable.
COL_NAME
Returns the column name for a given column ID.
COL_LENGTH
Returns the length of a column in bytes.
COLUMNPROPERTY
Returns a property of a column, such as whether it’s an identity or computed
column.
Inspect indexing structures and statistics freshness. Use this metadata in tuning workflows and
metadata-driven maintenance.
Description
INDEX_COL
Returns the name of an indexed column.
INDEXKEY_PROPERTY
Returns a property of an index key.
INDEXPROPERTY
Returns a property of an index, such as clustered or disabled.
STATS_DATE
Returns the date statistics were last updated for a table or index.
Inspect the physical layout (files and filegroups) and full-text components. Use this information
for storage management, troubleshooting, and configuration auditing.
Description
FILE_ID
Returns the file ID.
FILE_IDEX
Returns the file ID based on file name.
FILE_NAME
Returns the file name for a file ID.
FILEGROUP_ID
Returns a filegroup’s ID.
Expand table
Expand table