SHOW CREATE SYNC MATERIALIZED VIEW

Description

View the materialized view creation statement.

SHOW CREATE MATERIALIZED VIEW <materialized_view_name> ON <table_name>

1. <materialized_view_name>

The name of the materialized view.

2. <table_name>

The table to which the materialized view belongs.

The user executing this SQL command must have at least the following permissions:

Privilege	Object	Notes
SHOW_PRIV	Table	Requires SHOW_PRIV permission on the current materialized view

View the creation statement of an asynchronous materialized view
```
SHOW CREATE MATERIALIZED VIEW partition_mv;
```
View the creation statement of a synchronized materialized view
```
SHOW CREATE MATERIALIZED VIEW sync_agg_mv on lineitem;
```