Skip to content
Starburst Enterprise 413-e.1 LTS logo
Documentation: Starburst Enterprise 413-e.1 LTS SHOW CREATE MATERIALIZED VIEW
Filter:
Latest LTS (413-e) 407-e LTS 402-e LTS 393-e LTS 380-e LTS Latest STS (411-e)
  • Get started
  • Starburst Galaxy
  • Starburst Enterprise
  • Ecosystems
  • Resources
  • SQL statement syntax
  • Overview
  • Features, use cases, and support
  • For all users
  • Starburst Enterprise web UI
  • Clients
  • Data products
  • Insights
  • For data engineers
  • Query optimizer
  • Developer guide
  • For platform administrators
  • Manual installation and license
  • Deploying with Kubernetes
  • Deploying with CFT on AWS
  • Performance, logging, and governance features
  • Security
  • Starburst Enterprise REST API
  • Data sources
  • Connector overview
  • Object storage connectors
  • Non-object storage connectors
  • Utilities
  • Starburst connectors feature matrix
  • SQL reference
  • SQL language
  • SQL statement syntax
    • Statement listing
      • Statements A-F
      • Statements G-R
      • Statements S-Z
  • Functions and operators
  • Version information
  • 413-e.1 LTS and others
  • Release notes
  • Appendix
  • 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

Skip
Previous SHOW COLUMNS
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 413-e.1 LTS logo
  • Copyright © 2017-2023
    Starburst Data
  • Trademark information