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)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें