remove UNIQUE from SQL

[phpjaco]

how do i remove the unique field out of my db, so easy to put in but what a mission to get out.

Here is my query:
$sql = 'ALTER TABLE test DROP INDEX wth';

i keep getting a failure:Can't DROP 'heading'; check that column/key exists - in phpadmin i have tried it on a test table - it runs the query successfully but the text fields still remain unique

what am i doing wrong?

[tsinka]

Hi,

which indexes does phpmyadmin currently show on that table ?

Thomas

[phpjaco]

at the risk of sounding like a complete idiot, how do i check that?

[tsinka]

You can check that using phpbuilder.
Either select the table in the left menu and then post the contents of the table showing the indexes (below the table that shows the fields of the table) or select the table in the left menu and then choose to export the table in the top menu (structure only without the data).

[phpjaco]

head1_2 UNIQUE 3 head1

head1_3 UNIQUE 3 head1

head1_4 UNIQUE 3 head1

head1_5 UNIQUE 3 head1

head1_6 UNIQUE 3 head1

head1_7 UNIQUE 3 head1

More than one UNIQUE key was created for column head1

is this what you mean?

[tsinka]

Yes,

if you want the column not to be UNIQUE anymore then delete all unique indexes on that column (btw. it doesn't make sense to have multiple unique indexes on a single column).

[phpjaco]

hello, how do i check what the index names are if I don't have a phpmyadmin online? I have a website online but no access to phpMYadmin, how can i check what the names are of the indexes?

can this be done with standard sql?

[tsinka]

You can use sql:

SHOW INDEXES FROM tablename