DROP SCHEMA
Purpose
This statement deletes a schema and subsequently deletes all the objects with it.
Prerequisites
Physical Schema
- You need the system privilege
DROP ANY SCHEMA
, or the schema must be owned by you or one of your assigned roles.
Virtual Schema
- You need the system privilege
DROP ANY VIRTUAL SCHEMA
, or the schema must be owned by you or one of your assigned roles.
Syntax
drop_schema::=
Usage Notes
- A user can own arbitrary many schemas.
RESTRICT
deletes the schema only if it is empty.CASCADE
deletes the schema and subsequently deletes all objects contained in it. Additionally, all foreign key references to tables within the deleted schema are also removed.- If neither
CASCADE
norRESTRICT
is specified, thenRESTRICT
is applied by default. - If the optional clause
IF EXISTS
is specified, then the statement will not throw an exception if the schema does not exist. - For details about the virtual schema concept, refer to Virtual Schemas section.
- If you specify the
FORCE
option in the statement, then the corresponding adapter script is not informed by that action. Otherwise, the adapter script will be called and there will be an action depending on its implementation.