Commands
SHOW INDEXES
Use the SHOW INDEXES
command to view indexes from a particular table.
Syntax
Parameters
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. |
Example
We can create a table t3
and an index idx1
on t3
.
Next, we can use the SHOW INDEXES
command on t3
to see existing indexes.
Related topics
Was this page helpful?