Dropping an XML Schema Collection
To delete a complete XML schema collection and all its components, you can use the DROP XML SCHEMA COLLECTION statement. For more information, see DROP XML SCHEMA COLLECTION (Transact-SQL).
See Also
Reference
Managing XML Schema Collections on the Server
Guidelines and Limitations in Using XML Schema Collections on the Server
Permissions on an XML Schema Collection
Concepts
xml Data Type
Typed vs. Untyped XML