Chris White-4 wrote: > > Moving along... what I do first is SHOW > CREATE TABLE `table_name`: > ...snipped... > So, first you remove the key: > ALTER TABLE table_name DROP KEY `key_column`; > then the foreign key: > ALTER TABLE table_name DROP FOREIGN KEY `table_name_ibfk_1`; > ...snipped... > Thank you Chris. The SHOW CREATE TABLE `table_name` was just the ticket. It showed both the key name and the foreign key name. The foreign key hadn't shown up in phpMyAdmin or MySQLAdministrator - all very frustrating. I dropped the foreign key first and then the index. I'm sure leaving the work until after my own caffeine boost also helped considerably! Cheers! -- View this message in context: http://www.nabble.com/Deleting-Foreign-Key-tf2905915.html#a8171880 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
