Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Retrieve information about the namespaces in the schema collection

4>  SELECT N.* 5> FROM sys.xml_schema_namespaces AS N 6>   JOIN sys.xml_schema_collections AS C 7>     ON N.xml_collection_id = C.xml_collection_id 8> WHERE C.name = 'ContactOtherAttributes'; 9> GO xml_collection_id name                    xml_namespace_id ----------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------ ---------------- (0 rows affected) 1>