Skip to main content

SHOW CREATE INDEX

Use the SHOW CREATE INDEX command to see what query was used to create the specified index.

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

Help us make this doc better!