sys.xml_indexes (Transact-SQL)
Returns one row per XML index.
Column name | Data type | Description |
---|---|---|
<inherited columns> |
|
Inherits columns from sys.indexes. |
using_xml_index_id |
int |
NULL = Primary XML index. Nonnull = Secondary XML index. Nonnull is a self-join reference to the primary XML index. |
secondary_type |
char(1) |
Type description of secondary index: P = PATH secondary XML index V = VALUE secondary XML index R = PROPERTY secondary XML index NULL = Primary XML index |
secondary_type_desc |
nvarchar(60) |
Type description of secondary index: PATH = PATH secondary XML index VALUE = VALUE secondary XML index PROPERTY = PROPERTY secondary xml indexes. NULL = Primary XML index |
See Also
Reference
Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)