Use the SHOW INDEXES
command to view indexes from a particular table.
Parameter | Description |
---|---|
table_name | The table from which indexes will be displayed. |
LIKE_expression | Filters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions. |
t3
and an index idx1
on t3
.
SHOW INDEXES
command on t3
to see existing indexes.