sys.xml_indexes (Transact-SQL)
Applies to: SQL Server
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 |
xml_index_type | tinyint | Index type: 0 = Primary XML index 1 = Secondary XML index 2 = Selective XML index 3 = Secondary selective XML index |
xml_index_type_description | nvarchar(60) | Description of index type: PRIMARY_XML Secondary XML Index Selective XML Index Secondary Selective XML index |
path_id | int | NULL 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. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre