SHOW CREATE MATERIALIZED VIEW
Description
Shows the definition of a specific asynchronous materialized view.
tip
This operation does not require privileges.
Syntax
SHOW CREATE MATERIALIZED VIEW [database.]<mv_name>
Parameters in brackets [] is optional.
Parameters
Parameter | Required | Description |
---|---|---|
mv_name | yes | The name of the materialized view to show. |
Returns
Return | Description |
---|---|
Materialized View | The name of the materialized view. |
Create Materialized View | The definition of the materialized view. |