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