Library /sys$common/syshlp/RDOHELP72.HLB  —  DELETE_FIELD
    Deletes one or more field definitions. When the DELETE FIELD
    statement executes, Oracle Rdb deletes the field definition from the
    physical database. If you invoke the database using the PATHNAME
    argument, Oracle Rdb also deletes the field definition from the
    CDD$DATABASE definition of the database in the data dictionary.
    You can delete any named field, whether it was defined with a
    DEFINE FIELD statement or with a DEFINE RELATION statement.
    However, you cannot delete a field that is referred to in the
    definition of a relation, index, or constraint:

    Example:

    DELETE FIELD POSTAL_CODE.
Additional Information: explode extract
More Format Examples
Close Help