# 8. SQL Reference

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
SQL Reference
Datatypes
User Defined Types
XML Column Type
Identifier Case & Quoting
Wide Character Identifiers
Qualified Names
Literals, Brace Escapes
CREATE TABLE Statement
DROP TABLE Statement
CREATE INDEX Statement
DROP INDEX Statement
ALTER TABLE Statement
CREATE VIEW Statement
CREATE XML SCHEMA Statement
DROP XML SCHEMA Statement
Sequence Objects
INSERT Statement
UPDATE Statement
SELECT Statement
COMMIT WORK, ROLLBACK WORK Statement
CHECKPOINT, SHUTDOWN Statement
Stored Procedures as Views & Derived Tables
GRANT, REVOKE Statement
SET Statement
Best Effort Union
Standard and User-Defined Aggregate Functions
Virtuoso SQL Optimization
SQL Inverse Functions
SQL Grammar
Bitmap Indices

## 8.15. DROP XML SCHEMA Statement

    <xml schema removal> ::=
        DROP XML SCHEMA <target URI>

This reverts the effect of CREATE XML SCHEMA.

The <target URI> should be a string constant that is equal to the value of "targetNamespace" attribute of "xs:schema" element of a previously declared XML schema.

The statement signals an error if the XMLSchema to be dropped is used in some WITH SCHEMA constraint.

Previous CREATE XML SCHEMA Statement | Chapter Contents | Next Sequence Objects