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.
DROP SCHEMA schemaName RESTRICT
The name of the schema that you want to drop from your database.
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.
splice> DROP SCHEMA Baseball_Stats RESTRICT; 0 rows inserted/updated/deleted