Enables you to drop
a schema.
DROP SCHEMA [ "catalog"."schema" ] [ drop-disposition ]
“catalog”
Specifies the catalog
name.
“schema”
Specifies the schema
name.
drop-disposition
Specifies the drop
disposition and is one of the following values:
drop-disposition ::=
{RESTRICT | CASCADE} [FORCE]
| RESTRICT |
Specifies that the drop target is empty. This is
the default value.
|
| CASCADE |
Specifies that contained objects are dropped. |
| FORCE |
Specifies the optional FORCE keyword that will suppress
error messages when the data service does not exist. This additional
option does not affect the performance of the RESTRICT or CASCADE
options.
|
DROP SCHEMA "catalog1_BASE"."schema1_BASE"
DROP SCHEMA "catalog1_BASE"."schema1_BASE" force