Can I know about existing indexes / keys in my table? I would be wonder if there is any command to get an existing index in the MySQL table.
Answer No: 179
To view the keys or indexes on a table, MySQL provides the SHOW KEYS and SHOW INDEXES commands. You can use any of these commands. The result of both commands is the same. Take the following examples:
SHOW INDEXES FROM table_name;
SHOW KEYS FROM table_name;
Comments
Add Comments
Found a bug? Or do you have a better solution for this? Feel free to leave a message: