Export (0) Print
Expand All

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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft