Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x is based Doris 4.x (up to 4.0 supported). Versions on this page refer to Doris versions. See Version Mapping.

DROP ASYNC MATERIALIZED VIEW

Description​

This statement is used to delete asynchronous materialized views.

syntax:

DROP MATERIALIZED VIEW (IF EXISTS)? mvName=multipartIdentifier

  1. IF EXISTS: If the materialized view does not exist, do not throw an error. If this keyword is not declared and the materialized view does not exist, an error will be reported.

  2. mv_name: The name of the materialized view to be deleted. Required field.

Example​

  1. Delete table materialized view mv1
DROP MATERIALIZED VIEW mv1;

2.If present, delete the materialized view of the specified database

DROP MATERIALIZED VIEW IF EXISTS db1.mv1;

Keywords​

DROP, ASYNC, MATERIALIZED, VIEW

Best Practice​