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：

  1. SHOW CREATE MATERIALIZED VIEW [DBNAME.]MV_NAME

illustrate：

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

Example

  1. View the creation statement of mv1

    1. SHOW CREATE MATERIALIZED VIEW mv1;

Keywords

  1. SHOW, CREATE, MATERIALIZED, VIEW, ASYNC

Best Practice