To remove the foreign key constraint, run the "alter table drop foreign key" command.
alter table table name drop foreign key foreign key constraint name
This is a sample to remove the foreign key constraint called book_ibfk_1 in the book table.
alter table book drop foreign key book_ibfk_1
If you want to see what foreign key constraints are set, please refer to the following articles.