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>