Materialize/doc/user/content/sql/drop-materialized-view.md

---

title: "DROP MATERIALIZED VIEW" description: "DROP MATERIALIZED VIEW removes a materialized view from Materialize." menu: main:

parent: commands

---

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

{{< diagram "drop-materialized-view.svg" >}}

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:

{{< include-md file="shared-content/sql-command-privileges/drop-materialized-view.md" >}}

Related pages

• CREATE MATERIALIZED VIEW
• SHOW MATERIALIZED VIEWS
• SHOW CREATE MATERIALIZED VIEW
• DROP OWNED