Skip to content

Latest commit

 

History

History
38 lines (32 loc) · 1.66 KB

sys-xml-schema-namespaces-transact-sql.md

File metadata and controls

38 lines (32 loc) · 1.66 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sys.xml_schema_namespaces (Transact-SQL)
sys.xml_schema_namespaces (Transact-SQL)
rwestMSFT
randolphwest
06/10/2016
sql
system-objects
reference
sys.xml_schema_namespaces_TSQL
sys.xml_schema_namespaces
xml_schema_namespaces
xml_schema_namespaces_TSQL
sys.xml_schema_namespaces catalog view
TSQL

sys.xml_schema_namespaces (Transact-SQL)

[!INCLUDE SQL Server]

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

Column name Data type Description
xml_collection_id int ID of the XML schema collection that contains this namespace.
name nvarchar(4000) Name of XML namespace. Blank name indicates no target namespace.
xml_namespace_id int 1-based ordinal that uniquely identifies the XML namespace in the database.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

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