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.
