Deletes all other definitions (views, constraints, tables,
    sequences, indexes, and triggers) that refer to the named schema
    and then deletes that schema definition. This is known as a
    cascading delete.

    If you specify the CASCADE keyword, SQL deletes all definitions
    contained by the schema before deleting the schema.

    If you do not specify the CASCADE keyword, the schema must be
    empty.