DROP MATERIALIZED VIEW (Continuous Aggregate)

Drop a continuous aggregate view

Since 1.3.0

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

The syntax is:

DROP MATERIALIZED VIEW [IF EXISTS] <view_name>;

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

Returns

For standard DROP MATERIALIZED VIEW return behavior, see the PostgreSQL DROP MATERIALIZED VIEW documentation.