DROP MATERIALIZED VIEW#
Synopsis#
DROP MATERIALIZED VIEW [ IF EXISTS ] view_name
Description#
Drop an existing materialized view view_name.
The optional IF EXISTS clause causes the error to be suppressed if
the materialized view does not exist.
Examples#
Drop the materialized view orders_by_date:
DROP MATERIALIZED VIEW orders_by_date;
Drop the materialized view orders_by_date if it exists:
DROP MATERIALIZED VIEW IF EXISTS orders_by_date;