sys.xml_schema_namespaces (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row per XSD-defined XML namespace. The following tuples are unique: collection_id, namespace_id, and collection_id, and name.

Column nameData typeDescription
xml_collection_idintID of the XML schema collection that contains this namespace.
namenvarchar(4000)Name of XML namespace. Blank name indicates no target namespace.
xml_namespace_idint1-based ordinal that uniquely identifies the XML namespace in the database.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)

Community Additions

ADD
Show: