v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

DROP MATERIALIZED VIEW

Synopsis

Use the DROP MATERIALIZED VIEW statement to drop a materialized view.

Syntax

drop_matview ::= DROP MATERIALIZED VIEW [ IF EXISTS ] matview_name  
                 [ CASCADE | RESTRICT ]

drop_matview

DROPMATERIALIZEDVIEWIFEXISTSmatview_nameCASCADERESTRICT

Semantics

Drop a materialized view named matview_name. If matview_name already exists in the specified database, an error will be raised unless the IF NOT EXISTS clause is used.

RESTRICT / CASCADE

RESTRICT is the default and it will not drop the materialized view if any objects depend on it.

CASCADE will drop any objects that transitively depend on the materialized view.

Examples

Basic example.

yugabyte=# CREATE TABLE t1(a int4);
yugabyte=# CREATE MATERIALIZED VIEW m1 AS SELECT * FROM t1;
yugabyte=# CREATE MATERIALIZED VIEW m2 AS SELECT * FROM m1;
yugabyte=# DROP MATERIALIZED VIEW m1; -- fails because m2 depends on m1

ERROR:  cannot drop materialized view m1 because other objects depend on it
DETAIL:  materialized view m2 depends on materialized view m1

yugabyte=# DROP MATERIALIZED VIEW m1 CASCADE; -- succeeds

See also