DROP XML SCHEMA COLLECTION

Delete an entire XML schema collection and all of its components.

Syntax
      DROP XML SCHEMA COLLECTION [relational_schema.]sql_identifier

Key
   relational_schema   The relational schema name.
   sql_identifier      The XML schema collection to drop.

You cannot drop an XML schema collection if it is associated with any xml type parameter or column, specified in any table constraints or referenced in a schema-bound function / stored procedure (CREATE FUNCTION ... WITH SCHEMABINDING)

Example

DROP XML SCHEMA COLLECTION MySchemaCollection
GO

"The word schema comes from the Greek word "σχήμα" (skhēma) that means shape or more generally plan" - Wikipedia

Related commands:

CREATE XML SCHEMA COLLECTION
ALTER XML SCHEMA COLLECTION
Equivalent Oracle command:DBMS_XMLSAVE.deleteXML


© Copyright SS64.com 1999-2014
Some rights reserved