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
DROP MATERIALIZED VIEW [IF EXISTS] <view_name> [RESTRICT|CASCADE];
| Syntax element | Description |
|---|---|
| IF EXISTS | Optional. If specified, 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 | Optional. Do not drop this materialized view if any other views depend on it. (Default) |
| CASCADE | Optional. If specified, drop the materialized view and 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.