8.19. DROP VIEW

Synopsis

  1. DROP VIEW [ IF EXISTS ] view_name

Description

Drop an existing view.

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

Examples

Drop the view orders_by_date:

  1. DROP VIEW orders_by_date

Drop the view orders_by_date if it exists:

  1. DROP VIEW IF EXISTS orders_by_date

See Also

CREATE VIEW