VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping
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 Name | Description |
|---|---|
| TableName | Name of the table |
| ViewName | Name of the materialized view |
| CreateStmt | Statement used to create the materialized view |
Access Control Requirements
The user executing this SQL command must have at least the following permissions:
| Privilege | Object | Notes |
|---|---|---|
| SELECT_PRIV/LOAD_PRIV/ALTER_PRIV/CREATE_PRIV/DROP_PRIV | Table | You need to have permissions for the table to which the current materialized view belongs |
Examples
-
View the creation statement of a synchronized materialized view
SHOW CREATE MATERIALIZED VIEW sync_agg_mv on lineitem;