Permanently removes a materialized view from a MaxCompute project.
Syntax
DROP MATERIALIZED VIEW [IF EXISTS] [<project_name>.]<mv_name>;Parameters
| Parameter | Required | Description |
|---|---|---|
IF EXISTS | No | Suppresses the error if the materialized view does not exist. The statement completes silently without returning an error. Without this clause, the statement fails when the target view is not found. |
project_name | No | The name of the MaxCompute project that contains the materialized view. Defaults to the current project. To find your project name, log on to the MaxCompute console, select a region in the top navigation bar, and check the Project management tab. |
mv_name | Yes | The name of the materialized view to drop. |
Examples
Drop a materialized view named mv:
DROP MATERIALIZED VIEW mv;Drop a materialized view only if it exists:
DROP MATERIALIZED VIEW IF EXISTS mv;What's next
CREATE MATERIALIZED VIEW: Create a materialized view with clustering and partitioning support.
ALTER MATERIALIZED VIEW: Update a materialized view, manage its lifecycle, or drop partitions.
DESC TABLE/VIEW: View metadata about materialized views in a project.
SELECT MATERIALIZED VIEW: Query the status of a materialized view.