Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

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)