DROP SCHEMA

Contents

• DROP SCHEMA

  • Syntax

  • Examples

  • See Also

Syntax

DROP SCHEMA <schema_name> { CASCADE | RESTRICT }

Drop (delete) a schema.

If RESTRICT is specified and the schema is not empty, an error will be returned and no action will be taken.

If CASCADE is specified then schema is dropped including any objects within it.

Examples

DROP SCHEMA warehouse;

See Also

• CREATE SCHEMA