Purpose
This statement is used to drop a materialized view log.
Note
When deleting a materialized view log, if the base table is undergoing an active transaction operation, the deletion will be blocked until the transaction completes.
Privilege requirements
You must have the DROP TABLE privilege to drop a materialized view log. For more information about OceanBase AI Database privileges, see Permission classification.
Syntax
DROP MATERIALIZED VIEW LOG ON [database.] table;
Parameters
Parameters |
Description |
|---|---|
| database. | Optional. Specifies the database where the base table of the materialized view log is located. If omitted, database., the default base table is in your own database. |
| table | Specifies the name of the base table corresponding to the materialized view log. |
Examples
Delete the materialized view log on table test_tbl1.
obclient [test_db]> DROP MATERIALIZED VIEW LOG ON test_tbl1;
The return result is as follows:
Query OK, 0 rows affected