DROP SCHEMA Statement

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.
Examples:
DROP SCHEMA "catalog1_BASE"."schema1_BASE"
DROP SCHEMA "catalog1_BASE"."schema1_BASE" force