DROP CATALOG Statement

The DROP CATALOG statement enables you to drop a catalog by using this syntax:

DROP CATALOG "catalog" [ drop-disposition ]

Specifies the catalog name. Use double quotation marks when specifying the catalog name.

drop-disposition ::=
{RESTRICT | CASCADE} [FORCE]

Specifies the drop disposition as one of the following values:

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 CATALOG "Catalog3"

drop catalog "catalog1_BASE" cascade