SQL Server/T-SQL Tutorial/System Tables Views/sys.xml schema namespaces
Retrieve information about the namespaces in the schema collection
<source lang="sql">
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></source>