DROP MATERIALIZED VIEW LOG
Description
This statement is used to drop a materialized view log.
info
When dropping a materialized view log, if a transaction is currently running on the base table, the drop operation will be blocked until the transaction completes.
Privilege requirements
To drop a materialized view log, you must have the DROP TABLE privilege. For more information about the privileges of seekdb, see seekdb privilege types.
Syntax
DROP MATERIALIZED VIEW LOG ON [database.] table;
Parameters
| Parameter | Description |
|---|---|
| database. | Optional. Specifies the database where the base table of the materialized view log is located. If you omit database., the base table is assumed to be in your own database. |
| table | Specifies the name of the base table corresponding to the materialized view log. |
Examples
Drop the materialized view log on the test_tbl1 table.
DROP MATERIALIZED VIEW LOG ON test_tbl1;
The return result is as follows:
Query OK, 0 rows affected