DROP SCHEMA

Drop the specified schema.

Syntax

DROP SCHEMA schema-name RESTRICT

Description

The RESTRICT keyword enforces the rule that no objects can be defined in the specified schema for the schema to be deleted from the database. The RESTRICT keyword is required.

Example

DROP SCHEMA EMP RESTRICT

The EMP schema may only be deleted from the database if no objects are defined in the EMP schema.