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 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]