sys.xml_indexes (Transact-SQL)sys.xml_indexes (Transact-SQL)

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

每个 XML 索引对应返回一行。Returns one row per XML index.

列名Column name 数据类型Data type 描述Description
<继承列 ><inherited columns> 继承中的列sys.indexesInherits columns from sys.indexes.
using_xml_index_idusing_xml_index_id intint NULL = 主 XML 索引。NULL = Primary XML index.

Nonnull = 辅助 XML 索引。Nonnull = Secondary XML index.

Nonnull 是对主 XML 索引的自我联接引用。Nonnull is a self-join reference to the primary XML index.
secondary_typesecondary_type char(1)char(1) 辅助索引的类型说明:Type description of secondary index:

P = PATH 辅助 XML 索引P = PATH secondary XML index

V = VALUE 辅助 XML 索引V = VALUE secondary XML index

R = PROPERTY 辅助 XML 索引R = PROPERTY secondary XML index

NULL = 主 XML 索引NULL = Primary XML index
secondary_type_descsecondary_type_desc nvarchar(60)nvarchar(60) 辅助索引的类型说明:Type description of secondary index:

PATH = PATH 辅助 XML 索引PATH = PATH secondary XML index

VALUE = VALUE 辅助 XML 索引VALUE = VALUE secondary XML index

PROPERTY = PROPERTY 辅助 xml 索引。PROPERTY = PROPERTY secondary xml indexes.

NULL = 主 XML 索引NULL = Primary XML index
xml_index_typexml_index_type tinyinttinyint 索引类型:Index type:

0 = 主 XML 索引0 = Primary XML index

1 = 辅助 XML 索引1 = Secondary XML index

2 = 选择性 XML 索引2 = Selective XML index

3 = 辅助选择性 XML 索引3 = Secondary selective XML index
xml_index_type_descriptionxml_index_type_description nvarchar(60)nvarchar(60) 索引类型的说明:Description of index type:


辅助 XML 索引Secondary XML Index

选择性 XML 索引Selective XML Index

辅助选择性 XML 索引Secondary Selective XML index
path_idpath_id intint 对于除了辅助选择性 XML 索引以外的所有 XML 索引均为 NULL。NULL for all XML indexes except secondary selective XML index.

否则为对其生成辅助选择性 XML 索引的已提升路径的 ID。Else, the ID of the promoted path over which the secondary selective XML index is built. 该值与来自 sys.selective_xml_index_paths 系统视图的 path_id 的值相同。This value is the same value as path_id from sys.selective_xml_index_paths system view.


目录视图中仅显示用户拥有的安全对象的元数据,或用户对其拥有某些权限的安全对象的元数据。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. 有关详细信息,请参阅 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

请参阅See Also

目录视图 (Transact-SQL) Catalog Views (Transact-SQL)
对象目录视图(Transact SQL)Object Catalog Views (Transact-SQL)