DROP-ASYNC-MATERIALIZED-VIEW
DROP-ASYNC-MATERIALIZED-VIEW
Name
DROP ASYNC MATERIALIZED VIEW
Description
This statement is used to delete asynchronous materialized views.
syntax:
DROP MATERIALIZED VIEW (IF EXISTS)? mvName=multipartIdentifier
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.
mv_name: The name of the materialized view to be deleted. Required field.
Example
- 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