How to Remove a MySQL Table constraint
ALTER TABLE `attributes` DROP FOREIGN KEY `attributes_ibfk_1`;
MySQL ERROR 1005 (HY000): Can’t create table ‘Table.frm’ (errno: 150). Here’s the solution.
Example:
ALTER TABLE `race` DROP FOREIGN KEY `race_ibfk_1`;
ALTER TABLE `race`
ADD CONSTRAINT `race_ibfk_1` FOREIGN KEY (`specieId`) REFERENCES `specie` (`specieId`) ON DELETE CASCADE;
Tags: constraint, MySQL