DROP SCHEMA
Function
DROP SCHEMA removes the schema from the catalog.
Syntax
DROP SCHEMA schema_specificaton
where
schema_specification | A valid schema identifier representing the schema to be dropped. |
Description
DROP SCHEMA deletes an SQL schema entry from the CONNX catalog.
If DROP SCHEMA is statically invoked, the schema need not exist in the catalog during pre-compilation. The schema must exist at the time it is executed.
Limitations
It is not possible to drop the following schemas: DBO, PUBLIC, and INFORMATION_SCHEMA.
The CONNX CDD must have full catalog support enabled in the CONNX Data Dictionary Global Configuration Options.
Only the designated DBA and not even the owner is permitted to drop a schema. The DBA must be a member of the CDD group called CONNXCDDAdministrators:
Warning:
This statement is not subject to transaction logic. An implicit COMMIT is performed after successful execution of this statement. If an error is detected during execution of this statement, an implicit ROLLBACK is performed. Therefore, before executing this statement, it is strongly recommended to complete any open transaction containing INSERT, UPDATE and/or DELETE statements by issuing an explicit COMMIT or ROLLBACK statement.
CONNX Specifics
The inclusion of the keyword RESTRICT is optional. RESTRICT is assumed if no keyword is specified.
Examples
The following example drops the schema "Wiltshire":
DROP SCHEMA Wiltshire ;