user1701484
user1701484

Reputation: 233

I am unable to drop a foreign key in mysql

I am trying to drop a foriegn key in php admin (mysql) so I am performing this code below:

`ALTER TABLE Image_Question DROP INDEX FK_QuestionSession`

Problem is though that I am receiving this error:

#1553 - Cannot drop index 'FK_QuestionSession': needed in a foreign key constraint 

The foreign key for QuestionId is linked from the Image_Question Table to the QuestionId in the Question Table.

Thanks

Upvotes: 7

Views: 23127

Answers (1)

Zefiryn
Zefiryn

Reputation: 2265

Remove foreign key constrain first and then drop index. Otherwise you will always get error.

alter table Image_Question drop foreign key key_name_here

Upvotes: 19

Related Questions