SHOW-CREATE-ASYNC-MATERIALIZED-VIEW

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：

1. DBNAMNE : 数据库名称
2. MV_NAME : 异步物化视图的名称

Example

1. View the creation statement of mv1

   SHOW CREATE MATERIALIZED VIEW mv1;

Keywords

SHOW, CREATE, MATERIALIZED, VIEW, ASYNC

Best Practice