Updated on 2026-05-29 GMT+08:00

DROP MATERIALIZED VIEW

CASCADE: automatically deletes all objects that are contained in the schema to be deleted.
RESTRICT: refuses to delete the schema that contains any objects. This is the default.

Deletes a materialized view. This syntax is supported only by clusters of version 8.2.1.220 or later.

None

     DROP MATERIALIZED VIEW [ IF EXISTS ]
{[schema.]materialized_view_name} [, ...] [ CASCADE | RESTRICT ];

**Table 1** DROP MATERIALIZED VIEW parameters
Parameter	Description	Value Range
IF EXISTS	Sends a notice instead of an error if the specified materialized view does not exist.	-
materialized_view_name	Name of the materialized view to be deleted.	Name of an existing materialized view.
CASCADE \| RESTRICT	Specifies how to process related data in the dependent object when a delete operation is performed.	CASCADE: automatically deletes all objects that are contained in the schema to be deleted. RESTRICT: refuses to delete the schema that contains any objects. This is the default.

Delete a materialized view.

     DROP MATERIALIZED VIEW mv1;