drop-xml-schema-collection-transact-sql.md

title	DROP XML SCHEMA COLLECTION (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	11/25/2015
ms.prod	sql
ms.prod_service	sql-database
ms.service
ms.component	t-sql|statements
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	DROP XML SCHEMA COLLECTION DROP_XML_SCHEMA_COLLECTION_TSQL
dev_langs	TSQL
helpviewer_keywords	deleting XML schema collections XML schema collections [SQL Server], removing schema collections [SQL Server], removing removing XML schema collections dropping XML schema collections DROP XML SCHEMA COLLECTION statement
ms.assetid	d686f2f5-e03a-4ffe-a566-6036628f46f1
caps.latest.revision	15
author	douglaslMS
ms.author	douglasl
manager	craigg

DROP XML SCHEMA COLLECTION (Transact-SQL)

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

Deletes the whole XML schema collection and all of its components.

Transact-SQL Syntax Conventions

Syntax

  
DROP XML SCHEMA COLLECTION [ relational_schema. ]sql_identifier  

Arguments

relational_schema
Identifies the relational schema name. If not specified, the default relational schema is assumed.

sql_identifier
Is the name of the XML schema collection to drop.

Remarks

Dropping an XML schema collection is a transactional operation. This means when you drop an XML schema collection inside a transaction and later roll back the transaction, the XML schema collection is not dropped.

You cannot drop an XML schema collection when it is in use. This means that the collection being dropped cannot be any of the following:

• Associated with any xml type parameter or column.

• Specified in any table constraints.

• Referenced in a schema-bound function or stored procedure. For example, the following function will lock the XML schema collection MyCollection because the function specifies WITH SCHEMABINDING. If you remove it, there is no lock on the XML SCHEMA COLLECTION.

  CREATE FUNCTION dbo.MyFunction()  
  RETURNS int  
  WITH SCHEMABINDING  
  AS  
  BEGIN  
     ...  
     DECLARE @x XML(MyCollection)  
     ...  
  END;  
  

Permissions

To drop an XML SCHEMA COLLECTION requires DROP permission on the collection.

Examples

The following example shows removing an XML schema collection.

DROP XML SCHEMA COLLECTION ManuInstructionsSchemaCollection;  
GO  

See Also

CREATE XML SCHEMA COLLECTION (Transact-SQL)
ALTER XML SCHEMA COLLECTION (Transact-SQL)
EVENTDATA (Transact-SQL)
Compare Typed XML to Untyped XML
Requirements and Limitations for XML Schema Collections on the Server