Drop unique

pearl2 · #1 (**permalink**) 10-24-05, 09:31

Hi,

I've a table with two unique keys on the same column. I've no idea how the second one came about. Here's is a partial output from show create table profiles:

Code:

Create Table: CREATE TABLE 'profiles' {
  ...
  UNIQUE KEY 'email' (email),
  UNIQUE KEY 'email_2' (email)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

How do I drop the second unique key?

Thanks in anticipation

jfulton · #2 (**permalink**) 10-24-05, 10:30

Code:

ALTER TABLE `profiles` DROP INDEX `email_2`

pearl2 · #3 (**permalink**) 10-24-05, 10:42

Hi jfulton,

Thanks

I tried but it didn't work: ERROR 1064 (42000): You have an error in your SQL syntax; check....at line 1".

Edited:

Works without the single quotes around email_2

Thanks