SQL Server/T-SQL Tutorial/System Tables Views/sys.xml schema collections
Retrieve information about the components in the schema collection
<source lang="sql">
5> SELECT CP.* 6> FROM sys.xml_schema_components AS CP 7> JOIN sys.xml_schema_collections AS C 8> ON CP.xml_collection_id = C.xml_collection_id 9> WHERE C.name = "ContactOtherAttributes"; 10> GO xml_component_id xml_collection_id xml_namespace_id is_qualified name
symbol_space symbol_space_desc kind kind_desc derivation derivation_desc base_xml_component_id scoping_xml_component_id
----------------- ---------------- ------------ ---------------------------------------------------------------------------------------------------------------------------------------
------------ ------------------------------------------------------------ ---- -------------------------------------------------------
---------- ------------------------------------------------------------ --------------------- ------------------------
(0 rows affected)</source>