DROP VIEW [ IF EXISTS ] view_name;

DROP VIEW orders_by_date;
DROP VIEW IF EXISTS orders_by_date;