DROP MATERIALIZED VIEW

Syntax

drop materialized view [if exists] [<project_name>.]<mv_name>;

Parameters

• if exists: optional. If you do not specify if exists and the materialized view that you want to drop does not exist, an error is returned.
• project_name: Optional. The name of the MaxCompute project that contains the materialized view. If you omit this parameter, the current project is used. Log on to the MaxCompute console, switch the region in the upper-left corner, and find the project name on the Projects tab.
• mv_name: required. The name of the materialized view that you want to drop.

Examples

drop materialized view mv;

Related statements

• CREATE MATERIALIZED VIEW: Creates a materialized view that supports clustering and partitioning based on the data for materialized view scenarios.
• ALTER MATERIALIZED VIEW: Updates a materialized view, changes the lifecycle of an existing materialized view, enables or disables the lifecycle feature for a materialized view, or drops partitions from an existing materialized view.
• Syntax: Views the information about materialized views in a MaxCompute project.
• SELECT MATERIALIZED VIEW: Queries the status of a materialized view.