16

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.

user1032531
  • 1,711

2 Answers2

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.

drkblog
  • 2,665
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.

javier_domenech
  • 141