Library /sys$common/syshlp/RDOHELP72.HLB  —  CHANGE_RELATION
    Changes the definition of the fields and relation-specific
    constraints that make up a relation. You can add, delete, or
    change fields and relation-specific constraints in an existing
    relation. When you execute this statement, Oracle Rdb modifies the
    named field and relation-specific constraint definition(s) within
    the relation definition. All the fields that you do not mention
    remain the same.

    Example:

    RDO> CHANGE RELATION EMPLOYEES.
    cont>     DEFINE SALARY.
    cont> END EMPLOYEES RELATION.
    RDO> !
    RDO> CHANGE RELATION DEPARTMENTS.
    cont>    CHANGE DEPARTMENT_NAME
    cont>        QUERY_NAME FOR DATATRIEVE IS "DEPT".
    cont> END DEPARTMENTS RELATION.
Additional Information: explode extract
More Format Examples
Close Help