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

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

針對 XML 索引,各傳回一個資料列。Returns one row per XML index.

資料行名稱Column name 資料類型Data type 描述Description
<繼承的資料行><inherited columns> sys.databases繼承資料行。Inherits columns from sys.indexes.
using_xml_index_idusing_xml_index_id intint NULL = 主要 XML 索引。NULL = Primary XML index.

非 Null = 次要 XML 索引。Nonnull = Secondary XML index.

非 Null 是主要 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 索引的升級路徑識別碼。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)