|
| |
| 27. 22. 1. 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)
|
|
| 27. 22. sys.xml_schema_collections | | 27. 22. 1. | Retrieve information about the components in the schema collection | | |
|