Deletes one or more relation definitions and all associated
    relation-specific constraints. When the DELETE RELATION statement
    executes, Oracle Rdb deletes the relation definition, the storage
    map (if one exists), the constraints associated with the relation
    definition, and the data stored in that relation from the
    physical database. If you invoke the database using the PATHNAME
    argument, Oracle Rdb also deletes the relation definition from the
    CDD$DATABASE definition of the database in the data dictionary.

    Example:

    DELETE RELATION COLLEGES.