Languages

MySQL - how to view indexes of a table?

0 points
Asked by:
Teilsa
795

Do you know how to view indexes of a table in MySQL?

2 answers
0 points
Answered by:
Teilsa
795

I found a solution to the problem.

Query:

SHOW INDEX FROM `table_name` FROM `database_name`;

or

SHOW INDEX FROM `database_name`.`table_name`;
0 comments Add comment
0 points
Answered by:
Teilsa
795

Another solution when already using database is the following query:

SHOW INDEXES FROM `table_name`;

 

0 comments Add comment
Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Join to our subscribers to be up to date with content, news and offers.
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join