phpMyAdmin Removing an index

database indexing phpmyadmin unique
Samuel Meddows picture Samuel Meddows · Dec 1, 2010 · Viewed 65.1k times · Source

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

Michael Tabolsky picture Michael Tabolsky · Dec 1, 2010

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

Related questions

How does database indexing work?

Given that indexing is so important as your data set increases in size, can someone explain how indexing works at a database-agnostic level? For information on queries to index a field, check out How do I index a database column.

Read More
How to use index in select statement?

Lets say in the employee table, I have created an index(idx_name) on the emp_name column of the table. Do I need to explicitly specify the index name in select clause or it will automatically used to speed …

Read More
Multiple Indexes vs Multi-Column Indexes

I've just been adding an Index to a table in SQL Server 2005 and it got me thinking. What is the difference between creating 1 index and defining multiple columns over having 1 index per column you want to index. Are there certain …

Read More