Skip to content
Starburst Enterprise 475-e STS logo
Documentation: Starburst Enterprise 475-e STS SHOW CREATE MATERIALIZED VIEW
Product:
Latest LTS (474-e) 468-e LTS 462-e LTS 453-e LTS Latest STS (475-e)
  • 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
    • ALTER CATALOG
    • 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 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
    • SHOW STATS
    • SHOW TABLES
    • START TRANSACTION
    • TRUNCATE
    • UPDATE
    • USE
    • VALUES
  • Functions and operators
  • User-defined functions

For data engineers

  • Define catalogs
  • Object storage
  • Materialized views
  • Data maintenance
  • 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
Contents
  • 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 475-e STS logo
  • Copyright © 2017-2025
    Starburst Data
  • Trademark information