View existing indexes using phpMyAdmin

Question

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.

score 21 · Accepted Answer · answered Jun 09 '14 at 12:16

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.

answered Jun 09 '14 at 12:16

drkblog

2,615
15
13

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 09 '14 at 12:28
4

Ah, now I see. I must click the Indexes link! – user1032531 Jun 09 '14 at 12:31
Indexes are always in the Stucture tab but their position varies with different phpMyAdmin versions and themes. – drkblog Jun 09 '14 at 12:43

score 4 · Answer 2 · answered Aug 25 '16 at 10:05

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.

answered Aug 25 '16 at 10:05

javier_domenech

141
3

View existing indexes using phpMyAdmin

2 Answers2