sys.xml_schema_components (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version).|

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 has been 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)