Amazon Athena
User Guide

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 Deleting 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.

On this page: