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: +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | username | varchar(25) | | UNI | | | +----------+-------------+------+-----+---------+-------+ Anything I can do short of dumping the table, droping it, then re-inserting everything? Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
