Topic Status: Some information in this topic is pre-release and subject to change in future releases. Pre-release information describes new features or changes to existing features in Microsoft SQL Server 2014.
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).
ID of table with XML column.
Unique id of the selective xml index.
Promoted XML path id.
Promoted path. For example, '/a/b/c/d/e'.
0 = XQUERY
1 = SQL
Based on path_type value 'XQUERY' or 'SQL'.
Unique ID of the XML schema component in the database.
Name of the specified xsd type.
1 = type is inferred.
Max length (in character of xsd type).
1 = maximum length is inferred.
0 = node() hint not present.
1 = node() optimization hint applied.
ID of the system type of the column.
ID of the user type of the column.
Max Length (in bytes) of the type.
-1 = Column data type is varchar(max), nvarchar(max), varbinary(max), or xml.
Maximum precision of the type if it is numeric-based. Otherwise 0.
Maximum scale of the type if it is numeric-based. Otherwise, 0.
Name of the collation of the type if it is character-based. Otherwise, NULL.
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.