Skip to content

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;
Back to top