Deletes the specified catalog definition. You must delete all
    schemas and definitions contained in a catalog before you can
    delete that catalog. If other definitions exist that refer to the
    named catalog, the deletion fails.

    The DROP CATALOG statement lists all schemas and definitions that
    it is going to delete. You can roll back the statement if you do
    not want to delete these definitions.