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)

Help and Information

Getting SQL Server 2005 Assistance