Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

DROP VIEW

Drops (deletes) an existing view. The optional IF EXISTS clause causes the error to be suppressed if the view does not exist.

For more information, see Working with views.

Synopsis

DROP VIEW [ IF EXISTS ] view_name

Examples

DROP VIEW orders_by_date

DROP VIEW IF EXISTS orders_by_date

See also CREATE VIEW, SHOW COLUMNS, SHOW CREATE VIEW, SHOW VIEWS, and DESCRIBE VIEW.