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 |
Permissions
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.