Share via


sys.xml_schema_namespaces (Transact-SQL)

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

In SQL Server 2005 and later versions, 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.