DROP VIEW

Removes the specified view. Vertica does not check for dependencies on the dropped view. After dropping a view, other views that reference it will fail.

If you drop a view and replace it with another view or table with the same name and column names, other views that reference that name use the new view. If you change the column data type in the new view, the server coerces the old data type to the new one if possible; otherwise, it returns an error.

Syntax

DROP VIEW name [ , ... ]

Parameters

Privileges

To drop a view, you must be the view owner and have USAGE privileges on the schema or be the schema owner.

Examples

=> DROP VIEW myview;