Dropping views

Use the DROP VIEW statement to drop views. Any views that are dependent on the view being dropped are made inoperative.

Procedure

To drop a view by using the command line, enter:

   DROP VIEW view_name

Example

The following example shows how to drop a view named EMP_VIEW:

    DROP VIEW EMP_VIEW

As in the case of a table hierarchy, it is possible to drop an entire view hierarchy in one statement by naming the root view of the hierarchy, as in the following example:

   DROP VIEW HIERARCHY VPerson