RDOHELP72.HLB  —  DELETE_RELATION, More
    You must have the Oracle Rdb DELETE privilege to a relation to
    delete the relation with the DELETE RELATION statement.

    If the database is created with the DICTIONARY IS REQUIRED
    option, you must invoke the database by path name, rather than
    file name, before you issue this statement.

    You cannot delete a relation when there are other active
    transactions involving the relation. That is, you must have
    EXCLUSIVE access to the relation.

    If a view definition refers to a relation you want to delete, you
    must delete that view definition before you delete the relation.

    If a constraint in the database references a relation, you
    cannot delete that relation until you delete the constraint that
    references the relation.

    You must execute this statement in a read/write transaction.
    If there is no active transaction and you issue this statement,
    Oracle Rdb starts a read/write transaction implicitly.

    Other users are allowed to be attached to the database when you
    issue the DELETE RELATION statement.
Close Help