Developer Reference : Data Access Methods : SQL Engine Reference : SQL Syntax Reference : DROP VIEW
 
DROP VIEW
This statement removes a specified view from the database.
Syntax
DROP VIEW [ IF EXISTS ] view-name
 
view-name ::= user-defined name
Remarks
[CASCADE | RESTRICT] is not supported.
The expression IF EXISTS causes the statement to return success instead of an error if a view does not exist. IF EXISTS does not suppress other errors.
Examples
The following statement drops the vw_person view definition from the dictionary.
DROP VIEW vw_person
See Also
CREATE VIEW