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