Export (0) Print
Expand All

sys.selective_xml_index_paths (Transact-SQL)

Available beginning in SQL Server 2012 Service Pack 1, each row in sys.selective_xml_index_paths represents one promoted path for particular selective xml index.

If you create a selective xml index on xmlcol of table T using following statement,

CREATE SELECTIVE XML INDEX sxi1 ON T(xmlcol) 
FOR ( path1 = '/a/b/c' AS XQUERY 'xs:string',
      path2 = '/a/b/d' AS XQUERY 'xs:double'
    )

There will be two new rows in sys.selective_xml_index_paths corresponding to the index sxi1.

Applies to: SQL Server (SQL Server 2012 Service Pack 1 (SP1) through current version).

Column name

Data type

Description

object_id

int

ID of table with XML column.

index_id

int

Unique id of the selective xml index.

path_id

int

Promoted XML path id.

path

nvarchar(4000)

Promoted path. For example, '/a/b/c/d/e'.

name

sysname

Path name.

path_type

tinyint

0 = XQUERY

1 = SQL

path_type_desc

sysname

Based on path_type value 'XQUERY' or 'SQL'.

xml_component_id

int

Unique ID of the XML schema component in the database.

xquery_type_description

nvarchar(4000)

Name of the specified xsd type.

is_xquery_type_inferred

bit

1 = type is inferred.

xquery_max_length

smallint

Max length (in character of xsd type).

is_xquery_max_length_inferred

bit

1 = maximum length is inferred.

is_node

bit

0 = node() hint not present.

1 = node() optimization hint applied.

system_type_id

tinyint

ID of the system type of the column.

user_type_id

tinyint

ID of the user type of the column.

max_length

smallint

Max Length (in bytes) of the type.

-1 = Column data type is varchar(max), nvarchar(max), varbinary(max), or xml.

precision

tinyint

Maximum precision of the type if it is numeric-based. Otherwise 0.

scale

tinyint

Maximum scale of the type if it is numeric-based. Otherwise, 0.

collation_name

sysname

Name of the collation of the type if it is character-based. Otherwise, NULL.

is_singleton

bit

0 = SINGLETON hint not present.

1 = SINGLETON optimization hint applied.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft