SHOW-CREATE-ASYNC-MATERIALIZED-VIEW
Name
SHOW CREATE ASYNC MATERIALIZED VIEW
Description
This statement is used to display the creation statement of asynchronous materialized views.
grammar:
SHOW CREATE MATERIALIZED VIEW [DBNAME.]MV_NAME
illustrate:
DBNAMNE
: 数据库名称MV_NAME
: 异步物化视图的名称
Example
-
View the creation statement of mv1
SHOW CREATE MATERIALIZED VIEW mv1;
Keywords
SHOW, CREATE, MATERIALIZED, VIEW, ASYNC