DROP SCHEMA statement

The DROP SCHEMA statement drops a schema. The target schema must be empty for the drop to succeed.

Neither the APP schema (the default user schema) nor the SYS schema can be dropped.

Syntax

DROP SCHEMA schemaName RESTRICT

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 the SAMP schema
-- The SAMP schema may only be deleted from the database
-- if no objects are defined in the SAMP schema.

DROP SCHEMA SAMP RESTRICT