Use the DROP SCHEMA statement to drop a schema from the database.
Parameters, clauses, keywords, and variables
▪ RESTRICT: (default) Schema is dropped only if there are no objects that are associated with the specified schema.
▪ CASCADE: If the schema contains database objects (such as tables), those objects are dropped automatically. If you use the CASCADE keyword and the objects in other schemas reference an object in the schema that you are dropping, the references are resolved automatically by dropping those referencing objects or updating them to eliminate the reference.
Examples
DROP SCHEMA finance;
DROP SCHEMA finance CASCADE;
DROP SCHEMA finance RESTRICT;
DROP SCHEMA forecasting_db.securities_schema CASCADE;