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)

Examples

DROP XML SCHEMA COLLECTION MySchemaCollection
GO

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

Related commands

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