DROP MATERIALIZED VIEW

info

Materialized View support is now generally available (GA) and ready for production use.

If you are using versions earlier than 8.3.1, we suggest you upgrade at your earliest convenience.

DROP MATERIALIZED VIEW permanently deletes a materialized view and its contents.

The deletion is permanent and not recoverable, except if the view was created in a non-standard volume. In such cases, the view is only logically removed while the underlying data remains intact in its volume.

Disk space is reclaimed asynchronously after the materialized view is dropped.

Existing read queries for this view may delay space reclamation.

Syntax​

Flow chart showing the syntax of the DROP MATERIALIZED VIEW keyword

Example​

DROP MATERIALIZED VIEW trades_1h;

IF EXISTS​

Add an optional IF EXISTS clause after the DROP MATERIALIZED VIEW keywords to indicate that the selected materialized view should be dropped, but only if it exists.

See also​

For more information on the concept, see the the introduction and guide on materialized views.