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.