CODEWITHSUNDEEP
mysql
black
black

Reputation: 745

#1025 - Error on rename (errno: 150) in mysql

I am trying to drop a foreign key(id) in one table(misc) which is the primary key(id) in table(main). db name(xxx)

alter table misc drop FOREIGN KEY id

I am getting this error

#1025 - Error on rename of '.\interview#sql-edc_27' to '.\interview\misc' (errno: 150)

Upvotes: 8

Views: 26341

Answers (2)

ZooMMX
ZooMMX

Reputation: 938

In my case, was necessary to make a 3-step process (my table is named "articulos", and the hard-to-remove index is "FK_Departamento_ID")

  1. For knowing the name of table, I executed:

    SHOW INDEX FROM articulos;

  2. This statement resolved the issue (#1025, errno: 150), but the index remained in the table

    ALTER TABLE articulos DROP FOREIGN KEY FK_Departamento_ID;

  3. The following statement finally wiped out the index

    DROP INDEX FK_Departamento_ID ON articulos;

Upvotes: 2

Mihai
Mihai

Reputation: 26784

SHOW CREATE TABLE misc ;

You can't drop the foreign key using the column name,run the above query to find out the correct name,something like misc_ibfk_1

Heh,IT IS this name:

alter table misc drop FOREIGN KEY  misc_ibfk_1

Upvotes: 14

Related Questions