DROP SCHEMA removes the schema from the catalog.
Syntax
|
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:
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:
Caution: 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.
Example
The following example drops the schema "Wiltshire".
DROP SCHEMA Wiltshire ;