Home > DeveloperSection > Interviews > How can you see all indexes defined for a table?

Posted on    November-04-2011 4:24 AM

 MYSQL MYSQL 
Ratings:
 1 Answer(s)
  1229  View(s)
Rate this:

Chintoo Semi

Total Post:79

Points:395
Posted on    November-04-2011 12:00 AM

SHOW INDEX FROM techpreparation_questions;

where 'techpreparation_questions' is a table name.

Don't want to miss updates? Please click the below button!

Follow MindStick