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)