DROP MATERIALIZED VIEW (Continuous Aggregate)

Drop a continuous aggregate view

views can be dropped using the DROP MATERIALIZED VIEW statement.

This statement deletes the 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 , add the CASCADE option. Dropping a does not affect the data in the underlying from which the is derived.

DROP MATERIALIZED VIEW <view_name>;

Samples

Drop existing .

DROP MATERIALIZED VIEW contagg_view;

Arguments

Name	Type	Default	Required	Description
<view_name>	TEXT	-	✔	Name (optionally schema-qualified) of view to be dropped.