sys.xml_schema_components (Transact-SQL)
Applies to: 
SQL Server
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: NONE TYPE ELEMENT MODEL_GROUP ATTRIBUTE ATTRIBUTE_GROUP |
| 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: ANY_TYPE ANY_SIMPLE_TYPE PRIMITIVE_TYPE SIMPLE_TYPE LIST_TYPE UNION_TYPE COMPLEX_SIMPLE_TYPE COMPLEX_TYPE ELEMENT MODEL_GROUP ELEMENT_WILDCARD ATTRIBUTE ATTRIBUTE_GROUP ATTRIBUTE_WILDCARD |
| 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: NONE EXTENSION RESTRICTION SUBSTITUTION |
| 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 was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)