DB2 10.5 for Linux, UNIX, and Windows

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