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.
DROP MATERIALIZED VIEW [schema_name.]mv_name;
|schema_name||Specify the name of a schema to remove the materialized view in that schema. You can use |
|mv_name||The name of the materialized view to remove. You can use |
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;