SHOW ALTER TABLE MATERIALIZED VIEW
Descriptionβ
Check the status of the synchronized materialized view build task.
Since creating a synchronized materialized view is an asynchronous operation, after submitting the materialized view creation task, users need to asynchronously check the status of the synchronized materialized view build through a command.
Syntaxβ
SHOW ALTER TABLE MATERIALIZED VIEW FROM <database>
Required Parametersβ
1. <database>
The database to which the base table of the synchronized materialized view belongs.
Permissionsβ
The user executing this SQL command must have at least the following permissions:
| Privilege | Object | Notes |
|---|---|---|
| ALTER_PRIV | Table | Requires ALTER_PRIV permission on the table to which the current materialized view belongs |
Exampleβ
SHOW ALTER TABLE MATERIALIZED VIEW FROM doc_db;
