TechNet
Export (0) Print
Expand All

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.

Applies to: SQL Server (SQL Server 2008 through current version).
Column nameData typeDescription
xml_component_idintUnique ID of the XML schema component in the database.
xml_collection_idintID of the XML schema collection that contains the namespace of this component.
xml_namespace_idintID of the XML namespace within the collection.
is_qualifiedbit1 = 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.
namenvarchar

 (4000)
Unique name of the XML schema component. Is NULL if the component is unnamed.
symbol_spacechar(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_descnvarchar

 (60)
Description of space in which this symbol name is unique, based on kind:

NONE

TYPE

ELEMENT

MODEL_GROUP

ATTRIBUTE

ATTRIBUTE_GROUP
kindchar(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_descnvarchar

 (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
derivationchar(1)Derivation method for derived types:

N = None (not derived)

X = Extension

R = Restriction

S = Substitution
derivation_descnvarchar

 (60)
Description of derivation method for derived types:

NONE

EXTENSION

RESTRICTION

SUBSTITUTION
base_xml_component_idintID of the component from which this component is derived. NULL if there is none.
scoping_xml_component_idintUnique ID of the scoping component. NULL if there is none (global scope).

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.

Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft