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