Skip to content

xml-schema-namespace.md

Latest commit

 

History

History
72 lines (55 loc) · 3.34 KB

xml-schema-namespace.md

File metadata and controls

72 lines (55 loc) · 3.34 KB
title xml_schema_namespace (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 07/27/2017
ms.prod sql
ms.reviewer
ms.technology t-sql
ms.topic language-reference
f1_keywords
xml_schema_namespace_TSQL
xml_schema_namespace
dev_langs
TSQL
helpviewer_keywords
XML schema collections [SQL Server], reconstructing schemas
xml_schema_namespace function
reconstructing schemas
schemas [SQL Server], XML
schema collections [SQL Server], reconstructing schemas
ms.assetid ee9873d8-dd3a-4bff-a10c-68bbadbdf1a6
author MightyPen
ms.author genemi

xml_schema_namespace

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Reconstructs all the schemas or a specific schema in the specified XML schema collection. This function returns an xml data type instance.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
xml_schema_namespace( Relational_schema , XML_schema_collection_name , [ Namespace ] )

Arguments

Relational_schema
Is the relational schema name. Relational_schema is sysname.

XML_schema_collection_name
Is the name of the XML schema collection to reconstruct. XML_schema_collection_name is sysname.

Namespace
Is the namespace URI of the XML schema that you want reconstructed. It is limited to 1,000 characters. If Namespace URI is not provided, the whole XML schema collection is reconstructed. Namespace is nvarchar(4000).

Return Types

xml

Remarks

When you import XML schema components in the database by using CREATE XML SCHEMA COLLECTION or ALTER XML SCHEMA COLLECTION, aspects of the schema used for validation are preserved. Therefore, the reconstructed schema may not be lexically the same as the original schema document. Specifically, comments, white spaces, and annotations are lost; and implicit type information is made explicit. For example, <xs:element name="e1" /> becomes <xs:element name="e1" type="xs:anyType"/>. Also, namespace prefixes are not preserved.

If you specify a namespace parameter, the resulting schema document will contain definitions for all schema components in that namespace, even if they were added in different schema documents or DDL steps, or both.

You cannot use this function to construct XML schema documents from the sys.sys XML schema collection.

Examples

The following example retrieves the XML schema collection ProductDescriptionSchemaCollection from the production relational schema in the AdventureWorks database.

USE AdventureWorks;  
GO  
SELECT xml_schema_namespace(N'production',N'ProductDescriptionSchemaCollection');  
GO

See Also

View a Stored XML Schema Collection
XML Schema Collections (SQL Server)