doc/user/content/sql/drop-materialized-view.md
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.
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. |
DROP MATERIALIZED VIEW winning_bids;
DROP MATERIALIZED VIEW
DROP MATERIALIZED VIEW winning_bids;
ERROR: cannot drop materialize.public.winning_bids: still depended
upon by catalog item 'materialize.public.wb_custom_art'
The privileges required to execute this statement are:
{{% include-headless "/headless/sql-command-privileges/drop-materialized-view" %}}