DROP MATERIALIZED VIEW

Warning

Materialized views are experimental. The SPI and behavior may change in future releases.

To enable, set experimental.legacy-materialized-views = false in configuration properties.

Synopsis

DROP MATERIALIZED VIEW [ IF EXISTS ] view_name

Description

Drop an existing materialized view and delete its stored data.

The optional IF EXISTS clause causes the statement to succeed even if the materialized view does not exist.

Examples

Drop the materialized view daily_sales:

DROP MATERIALIZED VIEW daily_sales

Drop the materialized view if it exists:

DROP MATERIALIZED VIEW IF EXISTS daily_sales

See Also

CREATE MATERIALIZED VIEW, REFRESH MATERIALIZED VIEW, SHOW CREATE MATERIALIZED VIEW, Materialized Views