SQL statement syntaxSHOW CREATE MATERIALIZED VIEWOn this pageSHOW CREATE MATERIALIZED VIEW Synopsis SHOW CREATE MATERIALIZED VIEW view_name Description Show the SQL statement that creates the specified materialized view view_name. See also CREATE MATERIALIZED VIEW DROP MATERIALIZED VIEW REFRESH MATERIALIZED VIEW