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 INDEX index_name;

​
Parameters

ParameterDescription
index_nameThe index to show the query of.

​
Example

We can create a table t3 and an index idx1 on t3. 
CREATE TABLE IF NOT EXISTS t3 (
    v1 int,
    v2 int,
    v3 int);

CREATE INDEX idx1 ON t3 (v1,v2);
Next, we can use the SHOW CREATE INDEX command on idx1 to see the query used. 
SHOW CREATE INDEX idx1;

    Name     |           Create Sql
-------------+---------------------------------
 public.idx1 | CREATE INDEX idx1 ON t3(v1, v2)
(1 row)

CREATE INDEX