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.

Access Control Requirements

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

Privilege	Object	Notes
SHOW_PRIV	Table	Requires SHOW_PRIV permission on the current materialized view

Examples

1. View the creation statement of an asynchronous materialized view

   SHOW CREATE MATERIALIZED VIEW partition_mv;

2. View the creation statement of a synchronized materialized view

   SHOW CREATE MATERIALIZED VIEW sync_agg_mv on lineitem;