Skip to main content

DROP MATERIALIZED VIEW

Use the DROP MATERIALIZED VIEW command to remove a materialized view from the database.

Before you can remove a materialzied view, you must remove all its dependent materialzied views.

Syntax

DROP MATERIALIZED VIEW [schema_name.]mv_name;

Parameters

ParameterDescription
schema_nameSpecify the name of a schema to remove the materialized view in that schema. You can use SHOW SCHEMAS to get a list of all available schemas. If you don't specify a schema, the specified materialized view in the default schema "public" will be removed.
mv_nameThe name of the materialized view to remove. You can use SHOW MATERIALIZED VIEWS to get a list of all available materialized views.

Examples

This statement removes the "ad_ctr_5min" materialized view in the default schema ("public") from the database:

DROP MATERIALIZED VIEW ad_ctr_5min;

This statement removes the "ad_ctr_5min" materialized view in the "rw_schema" schema from the database:

DROP MATERIALIZED VIEW rw_schema.ad_ctr_5min;

Help us make this doc better!