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
