DROP SCHEMA statement

DROP SCHEMA statement The DROP SCHEMA statement removes the specified schema. DROP SCHEMA statementSchemasdropping

A schema is created by a .

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