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.