Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt

Use this file to discover all available pages before exploring further.

​
Syntax

SHOW CREATE MATERIALIZED VIEW mv_name;

​
Parameters

ParameterDescription
mv_nameThe materialized view to show the query of.

​
Example

CREATE MATERIALIZED VIEW v1 AS SELECT id FROM taxi_trips;
SHOW CREATE MATERIALIZED VIEW v1;
Here is the result. 
   Name    |                 Create Sql
-----------+---------------------------------------------
 public.v1 | CREATE MATERIALIZED VIEW v1 AS SELECT id FROM taxi_trips
(1 row)
SHOW CREATE VIEW SHOW CREATE TABLE

SHOW CREATE VIEW

SHOW CREATE TABLE