Skip to content
Starburst Enterprise 467-e STS logo
Documentation: Starburst Enterprise 467-e STS SHOW CREATE MATERIALIZED VIEW
Product:
Latest LTS (468-e) 462-e LTS 453-e LTS 443-e LTS Latest STS (469-e) 467-e STS
  • Introduction
  • Clients
  • Starburst Galaxy
  • Starburst Enterprise
  • Resources
  • SQL statement syntax

Get started

  • Overview
  • What is Starburst Enterprise?
  • Try Starburst Enterprise
  • Learn Starburst Enterprise
  • Product versions
  • Release notes
  • Get support

For all users

  • Starburst Enterprise web UI
  • Clients
  • Data products
  • Insights

Use SQL

  • SQL language
  • SQL statement syntax
    • Statement listing
      • Statements A-F
      • Statements G-R
      • Statements S-Z
        • SELECT
        • SET PATH
        • SET ROLE
        • SET SESSION
        • SET TIME ZONE
        • SHOW CATALOGS
        • SHOW COLUMNS
        • SHOW CREATE FUNCTION
        • 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
        • SET SESSION AUTHORIZATION
        • SHOW STATS
        • SHOW TABLES
        • START TRANSACTION
        • TRUNCATE
        • UPDATE
        • USE
        • VALUES
  • Functions and operators
  • SQL routines

For data engineers

  • Define catalogs
  • Object storage
  • Materialized views
  • Query optimizer

Connect to data sources

  • Connector overview
  • Object storage connectors
  • Non-object storage connectors
  • Utilities
  • Community-supported connectors
  • Starburst connectors feature matrix
  • Monitor and manage cost and performance

For platform administrators

  • Administration topics
  • Performance, logging, and governance features
  • Security
  • Starburst Enterprise REST API

Deploy in cloud ecosystems

  • AWS ecosystem
  • Google Cloud
  • Microsoft Azure
  • Red Hat OpenShift

SEP deployment mechanisms

  • Starburst Enterprise license
  • Deploy with Kubernetes
  • Deploy with Starburst Admin
  • Deploy with CFT on AWS
  • Local installation

Appendix

  • Trino developer guide
  • Version-specific notices and information
  • SHOW CREATE MATERIALIZED VIEW
    • 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

Is the information on this page helpful?

Yes

No

Cancel
"Previous" SHOW CREATE FUNCTION
"Next" SHOW CREATE SCHEMA

Resources

  • Starburst Enterprise reference documentation
  • Video library
  • Glossary
  • Free O'Reilly book - Trino: The Definitive Guide
  • Trino Community Broadcast
  • Starburst blog

Contact and more

  • Starburst
  • Join our weekly demos
  • Start a trial
  • Get support
  • Contact us
Starburst Enterprise 467-e STS logo
  • Copyright © 2017-2025
    Starburst Data
  • Trademark information