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. |