MySQL - how to view indexes of a table?

2 answers

0 points

Asked by:

345

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

2 answers

0 points

Answered by:

345

I found a solution to the problem.

Query:

SHOW INDEX FROM `table_name` FROM `database_name`;

SHOW INDEX FROM `database_name`.`table_name`;

0 comments Add comment

0 points

Answered by:

345

Another solution when already using database is the following query:

SHOW INDEXES FROM `table_name`;

0 comments Add comment

Get your tech brand or product in front of software developers.

For more information Contact us

Join