DROP SCHEMA

 

Function

DROP SCHEMA removes the schema from the catalog.

 

Syntax

drop_schema.bmp

 

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:

image3.jpg
 

 

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:
 

image4.gif
 

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 ;