alter table Drop / Deleting Foreign Key in MySQL

To remove the key:
ALTER TABLE table_name DROP KEY `key_column`;
To remove  foreign key:
ALTER TABLE table_name DROP FOREIGN KEY `table_name_ibfk_1`;

Comments