SHOW CREATE MATERIALIZED VIEW
Description
This statement is used to query statements that create materialized views.
grammar：
SHOW CREATE MATERIALIZED VIEW mv_name ON table_name
-
mv_name: Materialized view name. required.
-
table_name: The table name of materialized view. required.
Example
Create materialized view
create materialized view id_col1 as select id,col1 from table3;
Return after query
mysql> show create materialized view id_col1 on table3;
+-----------+----------+----------------------------------------------------------------+
| TableName | ViewName | CreateStmt |
+-----------+----------+----------------------------------------------------------------+
| table3 | id_col1 | create materialized view id_col1 as select id,col1 from table3 |
+-----------+----------+----------------------------------------------------------------+
1 row in set (0.00 sec)
Keywords
SHOW, MATERIALIZED, VIEW
