sys.xml_indexes (Transact-SQL)

[!INCLUDE SQL Server]

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
xml_index_type	tinyint	Index type: 0 = Primary XML index 1 = Secondary XML index 2 = Selective XML index 3 = Secondary selective XML index
xml_index_type_description	nvarchar(60)	Description of index type: PRIMARY_XML Secondary XML Index Selective XML Index Secondary Selective XML index
path_id	int	NULL for all XML indexes except secondary selective XML index. Else, the ID of the promoted path over which the secondary selective XML index is built. This value is the same value as path_id from sys.selective_xml_index_paths system view.

Permissions