SHOW CREATE MATERIALIZED VIEW¶
Warning
Materialized views are experimental. The SPI and behavior may change in future releases.
To enable, set experimental.legacy-materialized-views = false
in configuration properties.
Synopsis¶
SHOW CREATE MATERIALIZED VIEW view_name
Description¶
Show the SQL statement that creates the specified materialized view.
Examples¶
Show the SQL for the daily_sales materialized view:
SHOW CREATE MATERIALIZED VIEW daily_sales
See Also¶
CREATE MATERIALIZED VIEW, DROP MATERIALIZED VIEW, REFRESH MATERIALIZED VIEW, Materialized Views