Skip to content
Trino 435 Documentation logo
Trino 435 Documentation SHOW CREATE MATERIALIZED VIEW
Type to start searching
    Trino
    Trino
    • Overview
    • Installation
    • Clients
    • Security
    • Administration
    • Query optimizer
    • Connectors
    • Functions and operators
    • SQL language
    • SQL statement syntax
      • ALTER MATERIALIZED VIEW
      • ALTER SCHEMA
      • ALTER TABLE
      • ALTER VIEW
      • ANALYZE
      • CALL
      • COMMENT
      • COMMIT
      • CREATE CATALOG
      • CREATE FUNCTION
      • CREATE MATERIALIZED VIEW
      • CREATE ROLE
      • CREATE SCHEMA
      • CREATE TABLE
      • CREATE TABLE AS
      • CREATE VIEW
      • DEALLOCATE PREPARE
      • DELETE
      • DENY
      • DESCRIBE
      • DESCRIBE INPUT
      • DESCRIBE OUTPUT
      • DROP CATALOG
      • DROP FUNCTION
      • DROP MATERIALIZED VIEW
      • DROP ROLE
      • DROP SCHEMA
      • DROP TABLE
      • DROP VIEW
      • EXECUTE
      • EXECUTE IMMEDIATE
      • EXPLAIN
      • EXPLAIN ANALYZE
      • GRANT privilege
      • GRANT role
      • INSERT
      • MATCH_RECOGNIZE
      • MERGE
      • PREPARE
      • REFRESH MATERIALIZED VIEW
      • RESET SESSION
      • RESET SESSION AUTHORIZATION
      • REVOKE privilege
      • REVOKE role
      • ROLLBACK
      • SELECT
      • SET PATH
      • SET ROLE
      • SET SESSION
      • SET SESSION AUTHORIZATION
      • SET TIME ZONE
      • SHOW CATALOGS
      • SHOW COLUMNS
      • SHOW CREATE MATERIALIZED VIEW
        • Synopsis
        • Description
        • See also
      • SHOW CREATE SCHEMA
      • SHOW CREATE TABLE
      • SHOW CREATE VIEW
      • SHOW FUNCTIONS
      • SHOW GRANTS
      • SHOW ROLE GRANTS
      • SHOW ROLES
      • SHOW SCHEMAS
      • SHOW SESSION
      • SHOW STATS
      • SHOW TABLES
      • START TRANSACTION
      • TRUNCATE
      • UPDATE
      • USE
      • VALUES
      • Row pattern recognition in window structures
    • SQL routines
    • Developer guide
    • Glossary
    • Appendix
    • Release notes
    • Synopsis
    • Description
    • See also

    SHOW 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

    Previous SHOW COLUMNS
    Next SHOW CREATE SCHEMA