RDOHELP72.HLB  —  DELETE_FIELD, More
    o  You must have the Oracle Rdb DELETE privilege for a field to
       delete the field with the DELETE FIELD statement.

    o  If you want to delete a field that is part of a relation
       definition, you must use the CHANGE RELATION statement to
       delete the field from the relation definition, or you must
       delete the entire relation.

    o  If you want to delete a field that is referred to in a
       constraint or index definition, you must first delete the
       constraint or index.

    o  You cannot delete a field definition unless you have invoked
       the database that includes the field.

    o  You can delete a field definition even when there are
       active users. Deleting a field definition will not affect
       active users until they exit their session and invoke the
       database the next time. By default, a database can be opened
       automatically (that is, by any user who invokes the database
       and executes a data manipulation language statement). If the
       database was modified so that it must be manually opened, the
       RMU/OPEN command must be used to open it.

    o  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.
Close Help