SQL Server 2005 stores information about the XML that’s used in the server in a number of new system views. Table 7-1 briefly describes the new system XML views.
|
XML Catalog View |
Description |
|---|---|
|
sys.xml_attributes |
This view provides a row for each stored XML attribute. |
|
sys.xml_components |
This view provides a row for each component of an XML schema. |
|
sys.xml_component_placements |
This view provides a row for each placement of an XML component. |
|
sys.xml_elements |
This view provides a row for each XML component that is an XML element. |
|
sys.xml_facets |
This view provides a row for each facet (restriction) of an XML type. |
|
sys.xml_model_groups |
This view provides a list of all the XML component that are part of a Model-Group. |
|
sys.xml_namespaces |
This view provides a row for each XSD-defined namespace. |
|
sys.xml_types |
This view provides a row for each XML component that is an XML type. |
|
sys.xml_wildcards |
This view provides a row for each XML attribute or element wildcard. |
|
sys.xml_wildcard_namespaces |
This view provides a row for each XML wildcard namespace. |