Modifying Schema, View, Table, and Routine Definitions › Maintaining Schemas › Dropping an Existing Schema

Dropping an Existing Schema

DROP SCHEMA Statement

To drop a schema, use an SQL DDL DROP SCHEMA statement. This removes the named schema only if no tables or views are associated with it.

CASCADE Option

If you specify the CASCADE option, you also delete:

• The definition of each table and view associated with the named schema
• The data stored in each table associated with the schema
• The definition of each referential constraint, index, and CALC key defined on the tables associated with the named schema
• The view definition of each view derived from one or more of the tables associated with the named schema
• All privileges granted on tables dropped as a result of cascade processing

Considerations

If all tables and indexes on those tables are in a segment in which no other table or index from another schema resides, then you can use the FORMAT utility to erase rows and indexes before using DROP SCHEMA. This will enable more efficient execution.

Example

In the following example, a schema and its associated tables are dropped.

drop schema demoempl cascade;