• Article

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:

  • 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

In SQL Server 2005 and later versions, 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.