Example 1

    Delete a single view definition:

    RDO> INVOKE DATABASE PATHNAME "PERSONNEL"
    RDO> START_TRANSACTION READ_WRITE
    RDO> DELETE VIEW CURRENT_INFO.
    RDO> COMMIT

    This statement deletes the view definition from the physical
    database and the data dictionary.

    Example 2

    Delete more than one view definition:

    RDO> INVOKE DATABASE PATHNAME "PERSONNEL"
    RDO> START_TRANS READ_WRITE
    RDO> DELETE VIEW CURRENT_JOB.
    %RDMS-F-VIEWINVIEW, view, CURRENT_JOB, is referenced by view, CURRENT_INFO
    -RDMS-F-VIEWNOTDEL, view, CURRENT_JOB, has not been deleted
    RDO> DELETE VIEW CURRENT_INFO.
    RDO> DELETE VIEW CURRENT_SALARY.
    RDO> DELETE VIEW CURRENT_JOB.
    RDO> SHOW RELATIONS
    User Relations in Database with filename PERSONNEL
         COLLEGES
         DEGREES
         DEPARTMENTS
         EMPLOYEES
         JOBS
         JOB_HISTORY
         RESUMES
         SALARY_HISTORY
         WORK_STATUS
    RDO> COMMIT

    This sequence shows how to delete a set of views, some of which
    depend on others. In this case CURRENT_INFO is a view definition
    that combines fields from two other views, CURRENT_JOB and
    CURRENT_SALARY.