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

  1. DROP VIEW view_name [ IF EXISTS ];

Notes

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

Examples

  1. DROP VIEW foo;
  3. DROP VIEW foo IF EXISTS;