DROP SCHEMA

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

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

Syntax

DROP SCHEMA schemaName RESTRICT

schema

The name of the schema that you want to drop from your database.

RESTRICT

This is required. It enforces the rule that the schema cannot be deleted from the database if there are any objects defined in the schema.

Example

splice> DROP SCHEMA Baseball_Stats RESTRICT;
0 rows inserted/updated/deleted

See Also