1  DELETE_VIEW
   Deletes one or more view definitions. When the DELETE VIEW
   statement executes, Oracle Rdb deletes the view definition from the
   physical database and the data dictionary. You cannot delete a
   view if other views refer to it. You can delete a view definition
   when there are other users attached to the database.

   Example:

   RDO> DELETE VIEW CURRENT_SALARY.
 

2  Format

 (B)0DELETE VIEW qqqqwqqq> view-name qqqqqwqqq> .
                 mqqqqqqqqq , <qqqqqqqj

 

3  view-name
   The name of the view definition you want to delete.
 

2  Examples
   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.
 

2  More
   To delete a view with the DEFINE VIEW statement, you must have
   the Oracle Rdb DELETE privilege to the view.

   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.

   Deleting a view does not affect other users until you commit your
   transaction, and users detach from the database and attach again.