sys.xml_schema_components (Transact-SQL)
Returns a row per component of an XML schema. The pair (collection_id, namespace_id) is a compound foreign key to the containing namespace. For named components, the values for symbol_space, name, scoping_xml_component_id, is_qualified, xml_namespace_id, xml_collection_id are unique.
Column name |
Data type |
Description |
|---|---|---|
xml_component_id |
int |
Unique ID of the XML schema component in the database. |
xml_collection_id |
int |
ID of the XML schema collection that contains the namespace of this component. |
xml_namespace_id |
int |
ID of the XML namespace within the collection. |
is_qualified |
bit |
1 = This component has an explicit namespace qualifier. 0 = This is a locally scoped component. In this case, the pair, namespace_id, collection_id, refers to the "no namespace" targetNamespace. For wildcard components this value will be equal to 1. |
name |
nvarchar (4000) |
Unique name of the XML schema component. Is NULL if the component is unnamed. |
symbol_space |
char(1) |
Space in which this symbol name is unique, based on kind: N = None T = Type E = Element M = Model-Group A = Attribute G = Attribute-Group |
symbol_space_desc |
nvarchar (60) |
Description of space in which this symbol name is unique, based on kind:
|
kind |
char(1) |
Kind of XML schema component. N = Any Type (special intrinsic component) Z = Any Simple Type (special intrinsic component) P = Primitive Type (intrinsic types) S = Simple Type L = List Type U = Union Type C = Complex Simple Type (derived from Simple) K = Complex Type E = Element M = Model-Group W = Element-Wildcard A = Attribute G = Attribute-Group V = Attribute-Wildcard |
kind_desc |
nvarchar (60) |
Description of the kind of XML schema component:
|
derivation |
char(1) |
Derivation method for derived types: N = None (not derived) X = Extension R = Restriction S = Substitution |
derivation_desc |
nvarchar (60) |
Description of derivation method for derived types:
|
base_xml_component_id |
int |
ID of the component from which this component is derived. NULL if there is none. |
scoping_xml_component_id |
int |
Unique ID of the scoping component. NULL if there is none (global scope). |
Permissions
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.