 |
|
|
 | CREATE SCHEMA Statement |  | SQL Statements | CREATE USER Statement |  |
statement_DROP_SCHEMA ::= DROP [ IF EXISTS ] SCHEMA application_nameDescription
The DROP SCHEMA statement deletes an application (database schema) along with all contents. All objects, tables and data in the tables are deleted.
If the schema of the specified name does not exist in the database the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.
Only the Administrator or Author role has the privileges to delete an application.
WARNING: This is an operation that cannot be reversed (is not in one transaction)!
| CREATE SCHEMA Statement | | SQL Statements | CREATE USER Statement | |