Seeing indexes in a MySQL table

To show indexes on a MySQL table use any of the following commands in a MySQL client:

SHOW INDEX FROM table_name
SHOW INDEX IN table_name

SHOW INDEXES IN table_name

SHOW KEYS FROM table_name
SHOW KEYS IN table_name

Replace table_name with the actual table name. You can optionally append the following clause at the end of any query above to select the database to use.

FROM db_name
IN db_name

Replace db_name with the database name.

Did this tutorial help a little? How about buy me a cup of coffee?

Buy me a coffee at

Please feel free to use the comments form below if you have any questions or need more explanation on anything. I do not guarantee a response.

IMPORTANT: You must thoroughy test any instructions on a production-like test environment first before trying anything on production systems. And, make sure it is tested for security, privacy, and safety. See our terms here.