DROP MATERIALIZED VIEW (Continuous Aggregate)

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

This statement deletes the continuous aggregate and all its internal objects. It also removes refresh policies for that aggregate. To 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.

  2. DROP MATERIALIZED VIEW <view_name>;

Parameters

NameTypeDescription
<view_name>TEXTName (optionally schema-qualified) of continuous aggregate view to be dropped.

Sample usage

Drop existing continuous aggregate.

  2. DROP MATERIALIZED VIEW contagg_view;