How to View XML Schema Information

You can view information about the schema collections in a database by querying the sys.xml_schema_collections catalog
view, as shown in the following example.

SELECT * FROM sys.xml_schema_collections

You can also retrieve the individual XML namespaces defined in the database’s schema collections by querying the
sys.xml_schema_namespaces catalog view, as shown in the following example.

SELECT * FROM sys.xml_schema_namespaces

You can view the XML components defined in the database by querying the sys.xml_schema_components catalog view, as
shown in the following example.

SELECT * FROM sys.xml_schema_components