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

Answer 1

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

Answer 2

Follow this steps:-

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