DROP VIEW

Drop a view with the given name. If IF EXISTS is present, the statement won't fail if the view does not exist.

Synopsis

DROP VIEW view_name [ IF EXISTS ];

Notes

• view_name is a valid identifier.
• IF EXISTS annotation is optional.

Examples

DROP VIEW foo;

DROP VIEW foo IF EXISTS;