Re: Remove Unique Key

2005-07-20 Thread SGreen
Eric Jensen <[EMAIL PROTECTED]> wrote on 07/20/2005 02:00:26 PM: > I have a field that was set as a unique key when created via: > UNIQUE KEY `username` (`username`) > > I no longer want it unique, but can't see a way with ALTER TABLE to > remove it. It isn't the Primary Key or an index. The de

Re: Remove Unique Key

2005-07-20 Thread Joseph
www.mysql.com/doc search drop index Eric Jensen wrote: I have a field that was set as a unique key when created via: UNIQUE KEY `username` (`username`) I no longer want it unique, but can't see a way with ALTER TABLE to remove it. It isn't the Primary Key or an index. The describe looks lik

Remove Unique Key

2005-07-20 Thread Eric Jensen
I have a field that was set as a unique key when created via: UNIQUE KEY `username` (`username`) I no longer want it unique, but can't see a way with ALTER TABLE to remove it. It isn't the Primary Key or an index. The describe looks like this: +--+-+--+-+-+--