Syntax options:

    CASCADE | RESTRICT

    Performs a restricted delete by default. If you prefer to delete
    all definitions contained in the catalog, you can specify the
    DROP CATALOG CASCADE statement.