phpMyAdmin Removing an index

Question

I have a column in one of my tables which has been assigned an index. It is preventing me from having two of the same ID number.

I am assuming the reason it is not letting me have two entries of the same ID is because it has been set to be Unique.

I am wondering how do I remove this rule so that I can insert the same ID number several times.

Cheers

It may also be because that column was set as a key or primary key. Look at the table structure and the tools on that page. — DGH, Dec 01 '10 at 00:05
Cheers DGH. I'm pretty sure the guy who made the DB did make it primary. — Samuel Meddows, Dec 01 '10 at 00:48

score 97 · Accepted Answer · answered Dec 01 '10 at 00:17

97

below the list of your "columns" in the table structure you have a small table called "Indexes". Every row is an index. Find there your unique index and drop it using "drop" symbol (red X). If you have it on more than one column then drop it and recreate without the column you don't want unique

answered Dec 01 '10 at 00:17

Michael Tabolsky

3,429
2
18
11

13

In my current version pf PhpMyAdmin, the Indexes panel is collapsed by default. You first need to click on the `+ Indexes` link. (I am unable to determine which version this is...) – Ivo Renkema Aug 26 '16 at 08:06
1

How to Drop a unique index, without DROPPING the Field? – ejbytes May 11 '17 at 00:59
1

Yes, it's collapsed by default that's why people can't find it at first sight. – COil Oct 12 '17 at 09:39

vineet · Answer 2 · 2016-03-27T05:01:06.997

74

Follow this steps:-

Click Structure tab of table.
Click Index(below the table).
Click Drop for remove index(s).

enter image description here

edited Mar 27 '16 at 05:01

answered Mar 23 '15 at 07:49

vineet

13,832
10
56
76

This is an old post. On the new version i can only drop the whole Field. How can I avoid this? – ejbytes May 11 '17 at 01:01

score 13 · Answer 3 · answered Dec 12 '13 at 09:42

13

In the tab structure below the table the indexes are listed. In some versions of PHPMyAdmin the index are listed only if you click on "+Indexes" which is easy to overlook.

answered Dec 12 '13 at 09:42

Gunnar Bernstein

6,074
2
45
67

score 0 · Answer 4 · answered Dec 16 '18 at 18:17

0

ALTER TABLE dbName.table DROP INDEX indexName

answered Dec 16 '18 at 18:17

saeid sayadi

61
3

phpMyAdmin Removing an index

4 Answers4