Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)