Force drop mysql bypassing foreign key constraint
You can use the following steps, its worked for me to drop table with constraint,solution already explained in the above comment, i just added screen shot for that -
This might be useful to someone ending up here from a search. Make sure you're trying to drop a table and not a view.
SET foreign_key_checks = 0; -- Drop tables drop table ... -- Drop views drop view ... SET foreign_key_checks = 1;
SET foreign_key_checks = 0
is to set foreign key checks to off and then SET foreign_key_checks = 1
is to set foreign key checks back on. While the checks are off the tables can be dropped, the checks are then turned back on to keep the integrity of the table structure.
If you are using phpmyadmin then this feature is already there.
- Select the tables you want to drop
- From the dropdown at the bottom of tables list, select drop
- A new page will be opened having checkbox at the bottom saying "Foreign key check", uncheck it.
- Confirm the deletion by accepting "yes".