Description
You can use this statement to drop a materialized view.
Required privileges
You need the DROP TABLE privilege to drop a materialized view. For more information about privileges in OceanBase Database, see Privilege types in Oracle mode.
Syntax
DROP MATERIALIZED VIEW [ schema. ] materialized_view;
Parameters
| Parameter | Description |
|---|---|
| schema. | The schema where the materialized view is located. This parameter is optional. If you do not specify the schema. parameter, the system assumes by default that the materialized view resides in your own schema. |
| materialized_view | The name of the materialized view. |
Example
Drop the materialized view named mv_test_tbl1.
DROP MATERIALIZED VIEW mv_test_tbl1;
The return result is as follows:
Query OK, 0 rows affected
