DROP MATERIALIZED VIEW
DROP MATERIALIZED VIEW removes a materialized view from Materialize. If there
are other views depending on the materialized view, you must explicitly drop
them first, or use the CASCADE option.
Syntax
| Field | Use |
|---|---|
| IF EXISTS | Do not return an error if the named materialized view does not exist. |
| view_name | The materialized view you want to drop. For available materialized views, see SHOW MATERIALIZED VIEWS. |
| RESTRICT | Do not drop this materialized view if any other views depend on it. (Default) |
| CASCADE | Drop all views that depend on this materialized view. |
Examples
Dropping a materialized view with no dependencies
DROP MATERIALIZED VIEW winning_bids;
DROP MATERIALIZED VIEW
Dropping a materialized view with dependencies
DROP MATERIALIZED VIEW winning_bids;
ERROR: cannot drop materialize.public.winning_bids: still depended
upon by catalog item 'materialize.public.wb_custom_art'
Privileges
The privileges required to execute this statement are:
- Ownership of the dropped materialized view.
USAGEprivileges on the containing schema.