Commands
SHOW CREATE INDEX
Use the SHOW CREATE INDEX
command to see what query was used to create the specified index.
Syntax
Parameters
Parameter | Description |
---|---|
index_name | The index to show the query of. |
Example
We can create a table t3
and an index idx1
on t3
.
Next, we can use the SHOW CREATE INDEX
command on idx1
to see the query used.
Related topics
Was this page helpful?