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

[David Chell]

CREATE TABLE `bwschnzl`.`taccount` (
`AccountID` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`AccountID`)
) ENGINE=InnoDB;

If I rename it to Account2 it works, There was previously in the database a table of the same name which I deleted while SET FOREIGN_KEY_CHECKS=1 because there were foreign keys referencing the table. I wondered if the existing foreign key referencing the table being created was causing the problem so I ran a query to search for all foreign keys referencing tAccount and removed all of these references, but still I can't create the table.