Skip to main content

SHOW CREATE SYNC MATERIALIZED VIEW

Description

View the materialized view creation statement.

Syntax

SHOW CREATE MATERIALIZED VIEW <materialized_view_name> ON <table_name>

Required Parameters

1. <materialized_view_name>

The name of the materialized view.

2. <table_name>

The table to which the materialized view belongs.

Return Values

Column NameDescription
TableNameName of the table
ViewNameName of the materialized view
CreateStmtStatement used to create the materialized view

Access Control Requirements

The user executing this SQL command must have at least the following permissions:

PrivilegeObjectNotes
SELECT_PRIV/LOAD_PRIV/ALTER_PRIV/CREATE_PRIV/DROP_PRIVTableYou need to have permissions for the table to which the current materialized view belongs

Examples

  1. View the creation statement of a synchronized materialized view

    SHOW CREATE MATERIALIZED VIEW sync_agg_mv on lineitem;