VeloDB Cloud
SQL Manual
SQL Statements
Show
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