Geek Answers Handbook

MySQL reset field; foreign key errore 150

Problems with MySQL using InnoDB and deleting an unused foreign key. The foreign key refers to another table identifier. However, I do not need this.

I tried to remove the fk index, which does not work - says that this is necessary in relation to the foreign key. And deleting the field that gives me an error:

1025 - Error renaming './axis/#sql-ad8_1531' to './axis/Schedule' (errno: 150)

The table is currently empty. There are no tables in this field. Any ideas on how to get rid of this? Besides creating a new table?

If I read the error below correctly, I cannot delete the column because the index fk is declared. And I cannot discard the index because the column exists. Chicken and Egg?

LAST FOREIGN KEY ERROR 111004 17:05:40 Table axis foreign key constraint error / Schedule: the table does not have an index that contains columns as the first columns or the data types in the table do not match the tables specified in the table or one of the ON columns ... SET NULL is declared NOT NULL. Restriction:, CONSTRAINT "fk_Schedule_Grp" FOREIGN KEY ("idGrp") REFERENCES "Grp" ("idGrp") ON DELETE NO ACTIONS FOR UPDATES NO ACTIONS InnoDB: rename table axis. before axis. Schedulefailed!

+5
source share
1 answer

You need to use

ALTER TABLE table_name DROP FOREIGN KEY constraint_name

constraint_name - , . , , , SHOW CREATE TABLE. , CONSTRAINT.

: , ,

ALTER TABLE table_name DROP FOREIGN KEY fk_Schedule_Grp
+14

More articles:


All Articles