solidDB Help : solidDB reference : SQL: Statements : DROP CATALOG
  
DROP CATALOG
DROP CATALOG catalog‑name [CASCADE | RESTRICT]
Access requirements
SYS_ADMIN_ROLE role.
Usage
Use the DROP CATALOG statement to drop a catalog from the database.
Parameters, clauses, keywords, and variables
▪ RESTRICT: (default) Catalog is dropped only if it does not contain any database objects, for example tables.
▪ CASCADE: If the catalog contains database objects (such as tables), those objects are dropped automatically. If you use the CASCADE keyword and the objects in other catalogs reference an object in the catalog that you are dropping, the references are resolved automatically by dropping those referencing objects or updating them to eliminate the reference.
Examples
DROP CATALOG C1;
DROP CATALOG C2 CASCADE;
DROP CATALOG C3 RESTRICT;
Go up to
SQL: Statements