SQL Server/T-SQL Tutorial/System Tables Views/sys.xml schema collections

Retrieve information about the components in the schema collection

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)