1005 - Can't create table 'xxx' (errno: 150)

updated at 

Apply OS: Windows, macOS, Linux, iOS

Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All


There are some possible cases that might cause failure on creating Foreign Keys or Tables on MySQL database. These errors are related to MySQL itself.

Example cases:

  1. If the two fields (Field name and the Foreign Field name) are using incompatible field type, MySQL will return the error.
  2. If you use "On Delete Set Null" but the field doesn't allow null, MySQL will return the error.

There may be various cases to cause the same error. For more information, please feel free to visit at http://dev.mysql.com/doc/refman/5.1/en/cannot-create.html

Related articles

Have more questions?
Submit Ticket