Use the DROP MATERIALIZED VIEW
command to remove a materialized view from the database.
Parameter | Description |
---|---|
schema_name | Specify 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_name | The name of the materialized view to remove. You can use SHOW MATERIALIZED VIEWS to get a list of all available materialized views. |
CASCADE option | If this option is specified, all objects (such as other materialized views or regular views) that depend on the materialized view, and in turn all objects that depend on those objects will be dropped. |
ad_ctr_5min
materialized view in the default schema (public
) from the database:
ad_ctr_5min
materialized view in the rw_schema
schema from the database: