solidDB Help : solidDB reference : SQL: Statements : DROP SCHEMA
  
DROP SCHEMA
DROP SCHEMA [catalog‑name.]schema‑name [CASCADE | RESTRICT]
Access requirements
Database user
Usage
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;
Go up to
SQL: Statements