System XML Catalog Views


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.

Table 7-1: SQL Server 2005 XML Catalog 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.




Microsoft SQL Server 2005 New Features
Microsoft SQL Server 2005 New Features
ISBN: 0072227761
EAN: 2147483647
Year: 2005
Pages: 80
Authors: Michael Otey

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net