SHOW CREATE ASYNC MATERIALIZED VIEW
Descriptionβ
View the materialized view creation statement.
Syntaxβ
SHOW CREATE MATERIALIZED VIEW <materialized_view_name>
Required Parametersβ
1. <materialized_view_name>
The name of the materialized view.
Return Valuesβ
| Column Name | Description |
|---|---|
| Materialized View | Name of the materialized view |
| Create Materialized View | Statement used to create the materialized view |
Access Control Requirementsβ
The user executing this SQL command must have at least the following permissions:
| Privilege | Object | Notes |
|---|---|---|
| SELECT_PRIV/LOAD_PRIV/ALTER_PRIV/CREATE_PRIV/DROP_PRIV | Table |
Exampleβ
-
View the creation statement of an asynchronous materialized view
SHOW CREATE MATERIALIZED VIEW partition_mv;
