# SHOW CREATE MATERIALIZED VIEW
#### 语法
SHOW CREATE MATERIALIZED VIEW materialized_view_name
#### 描述
显示用于创建物化视图的SQL语句。
#### 示例
显示创建物化视图的SQL语句。
```
hetuengine:tpcds_2gb> show create materialized view mv.tpcds.test;
             Create Materialized View
---------------------------------------------------
 CREATE MATERIALIZED VIEW mv.tpcds.test ( c1, id )
 WITH (
    storage_table = 'mppdb.tpcds.test'
 ) AS
 SELECT
   c1
 , id
 FROM
   t1
WHERE (id < 7)
```