DROP VIEW#

Synopsis#

DROP VIEW [ IF EXISTS ] view_name
Copy to clipboard

Description#

Drop an existing view.

The optional IF EXISTS clause causes the error to be suppressed if the view does not exist.

Examples#

Drop the view orders_by_date:

DROP VIEW orders_by_date
Copy to clipboard

Drop the view orders_by_date if it exists:

DROP VIEW IF EXISTS orders_by_date
Copy to clipboard

See also#

CREATE VIEW