selective_xml_index_paths


Columns

Column Type Size Nulls Auto Default Children Parents Comments
object_id int 4 null
index_id int 4 null
path_id int 4 √ null
path nvarchar 8000 √ null
name nvarchar 256 √ null
path_type tinyint 1 √ null
path_type_desc nvarchar 256 √ null
xml_component_id int 4 √ null
xquery_type_description nvarchar 8000 √ null
is_xquery_type_inferred bit 1 √ null
xquery_max_length int 4 √ null
is_xquery_max_length_inferred bit 1 √ null
is_node bit 1 √ null
system_type_id tinyint 1 √ null
user_type_id tinyint 1 √ null
max_length smallint 2 √ null
precision tinyint 1 √ null
scale tinyint 1 √ null
collation_name sysname 256 √ null
is_singleton bit 1 √ null

Relationships