DROP MATERIALIZED VIEW (Continuous Aggregate) Community

Continuous aggregate views can be dropped using the DROP MATERIALIZED VIEW statement.

This statement deletes the continuous aggregate and all its internal objects. To also delete other dependent objects, such as a view defined on the continuous aggregate, add the CASCADE option. Dropping a continuous aggregate does not affect the data in the underlying hypertable from which the continuous aggregate is derived.

  1. DROP MATERIALIZED VIEW <view_name>;

Parameters

NameDescription
<view_name>Name (optionally schema-qualified) of continuous aggregate view to be created.

Sample Usage

Drop existing continuous aggregate.

  1. DROP MATERIALIZED VIEW contagg_view;