15

Using phpMyAdmin, is it possible to view existing indexes on a table? If so,how? One of my tables should have an unique index with two keys, and I want to confirm it exists.

21

Yes it is. You have to get into the database, select the table and then go to Structure tab. Below the columns definitions is the list of indexes for the table.

3
  • Thank you. I must be blind. I expected I would see it in the structure tab, yet I do not see any indexes. – user1032531 Jun 9 '14 at 12:28
  • 4
    Ah, now I see. I must click the Indexes link! – user1032531 Jun 9 '14 at 12:31
  • Indexes are always in the Stucture tab but their position varies with different phpMyAdmin versions and themes. – drkblog Jun 9 '14 at 12:43
4

At the structure tab, bellow the columns there is a link indexes, just click there and another table will show all the indexes related.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.