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;
 

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.