DROP VIEW
This statement removes a specified view from the database.
Syntax
DROP VIEW view-name
 
view-name ::= user-defined name
Remarks
[CASCADE | RESTRICT] is not supported.
Examples
The following statement drops the vw_person view definition from the dictionary.
DROP VIEW vw_person
See Also
CREATE VIEW