Contains a row per index or heap of a tabular object, such as a table, view, or table-valued function.
ID of the object to which this index belongs.
Name of the index. name is unique only within the object.
NULL = Heap
ID of the index. index_id is unique only within the object.
0 = Heap
1 = Clustered index
> 1 = Nonclustered index
Type of index:
0 = Heap
1 = Clustered
2 = Nonclustered
3 = XML
4 = Spatial
Description of index type:
1 = Index is unique.
0 = Index is not unique.
ID of the data space for this index. Data space is either a filegroup or partition scheme.
0 = object_id is a table-valued function.
1 = IGNORE_DUP_KEY is ON.
0 = IGNORE_DUP_KEY is OFF.
1 = Index is part of a PRIMARY KEY constraint.
1 = Index is part of a UNIQUE constraint.
> 0 = FILLFACTOR percentage used when the index was created or rebuilt.
0 = Default value
1 = PADINDEX is ON.
0 = PADINDEX is OFF.
1 = Index is disabled.
0 = Index is not disabled.
1 = Index is hypothetical and cannot be used directly as a data access path. Hypothetical indexes hold column-level statistics.
0 = Index is not hypothetical.
1 = Index allows row locks.
0 = Index does not allow row locks.
1 = Index allows page locks.
0 = Index does not allow page locks.
1 = Index has a filter and only contains rows that satisfy the filter definition.
0 = Index does not have a filter.
Expression for the subset of rows included in the filtered index.
NULL for heap or non-filtered index.
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.