How to Remove a MySQL Table constraint

Posted on August 26, 2008 by Raymond

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;

About Raymond

I'm a Christian web developer from the Philippines. Sometimes I write also.

This entry was posted in MySQL, SQL and tagged constraint, MySQL. Bookmark the permalink.