Modify Foreign Key
April 6th, 2009
To modify a Foreign Key in MySQL follow this steps :
1) Show table to see what is the name of Foreign Key we want to delete
SHOW CREATE TABLE table
2) Delete the Foreign Key
ALTER TABLE table DROP FOREIGN KEY table_ibfk_x
3) Create the new Foreign Key
ALTER TABLE table ADD CONSTRAINT `table_ibfk_x` FOREIGN KEY (`Field_id`) REFERENCES `references_table` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION