DROP XML SCHEMA COLLECTION (Transact-SQL)
Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Deletes the whole XML schema collection and all of its components.
Applies to: SQL Server (SQL Server 2008 through current version).
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;
The following example shows removing an XML schema collection.
DROP XML SCHEMA COLLECTION ManuInstructionsSchemaCollection; GO