Re: ERROR 1005: Can't create table (errno: 150)

[Chris Yuan]

I've read all the threads but still found no solution to the ALTER TABLE problem with foreign key...

I've checked very carefully the table type and column types to make sure everything matches, but still no luck...

Just like Michael I can create tables with foreign keys without any problem, but the problem comes when i'm trying to do ALTER TABLE...even with the MySQL Query Browser I can't modify the foreign key as the given SQL by the tool would also fail as the following:

ALTER TABLE `bank`.`employee` DROP FOREIGN KEY `FK_employee_1`,
ADD CONSTRAINT `FK_employee_1` FOREIGN KEY `FK_employee_1` (`name`)
REFERENCES `branch` (`name`)
ON DELETE SET NULL
ON UPDATE CASCADE
, AUTO_INCREMENT = 1;