Section 7.10. XML Catalog Views


7.10. XML Catalog Views

The catalog views described in Table 7-8 return information about the xml entities in a database.

Table 7-8. Catalog views for XML entities

Catalog view

Description

sys.xml_attributes

A row per xml component that is an attribute (symbol_space = A).

This view inherits from sys.xml_components.

sys.xml_component_placements

A row per placement for xml components.

sys.xml_components

A row per component of an XML schema.

sys.xml_elements

A row per xml component that is an element (symbol_space = E).

This view inherits from sys.xml_components.

sys.xml_facets

A row per facet of an xml-type definition.

This view inherits from sys.xml_components.

sys.xml_indexes

A row per xml index.

This view inherits from sys.indexes.

sys.xml_model_groups

A row per xml component that is a Model-Group (symbol_space = M).

This view inherits from sys.xml_components.

sys.xml_schema_collections

A row per XML schema collection.

sys.xml_schema_components

A row per XML schema component.

sys.xml_schema_namespaces

A row per XSD-defined XML namespace.

sys.xml_types

A row per xml component that is a Type (symbol_space = T).

This view inherits from sys.xml_components.

sys.xml_wildcard_namespaces

A row per enumerated namespace for an xml wildcard.

sys.xml_wildcards

A row per xml component that is an Attribute-Wildcard (kind V) or Element-Wildcard (kind W) both with symbol_space = N.

This view inherits from sys.xml_components.




Programming SQL Server 2005
Programming SQL Server 2005
ISBN: 0596004796
EAN: 2147483647
Year: 2007
Pages: 147
Authors: Bill Hamilton

Similar book on Amazon

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