sys.xml_indexes (Transact-SQL)


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns one row per XML index.

Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12.
Column nameData typeDescription
<inherited columns>Inherits columns from sys.indexes.
using_xml_index_idintNULL = Primary XML index.

Nonnull = Secondary XML index.

Nonnull is a self-join reference to the primary XML index.
secondary_typechar(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_descnvarchar(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_typetinyintIndex type:

0 = Primary XML index

1 = Secondary XML index

2 = Selective XML index

3 = Secondary selective XML index
xml_index_type_descriptionnvarchar(60)Description of index type:


Secondary XML Index

Selective XML Index

Secondary Selective XML index
path_idintNULL 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.

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.

Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)

Community Additions