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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho