Dropping typed views

To delete a typed view, use the DROP statement.

• To drop a typed view, issue a DROP VIEW statement.
  The following example shows how to drop the EMP_VIEW:

     DROP VIEW EMP_VIEW;

  Any views that are dependent on the dropped view become inoperative.
• To drop an entire view hierarchy in one statement, issue a DROP VIEW HIERARCHY statement.
  In the following example, VPerson is the root view in the typed view hierarchy:

     DROP VIEW HIERARCHY VPerson;