>I made a mistake of not giving a name to an index.
>alter table sometable add index ( field1, field2 )

>I would like to remove this index but I can't figure it out.

If you perform SHOW INDEX FROM tablename; what do you get as the key_name? Try 
dropping it based on what you see.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to