sys.xml_schema_namespaces (Transact-SQL)

sys.xml_schema_namespaces (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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

Applies to: SQL Server (SQL Server 2008 through current version).

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.

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.

Community Additions

ADD
Show:
© 2016 Microsoft