Skip to content

Instantly share code, notes, and snippets.

@janzell

janzell/force-drop-table-bypass-foreign-key.sql

Last active August 15, 2021 10:19
Show Gist options
  • Save janzell/dfe0041bdb5283ec8fc7f5db787ce348 to your computer and use it in GitHub Desktop.
Save janzell/dfe0041bdb5283ec8fc7f5db787ce348 to your computer and use it in GitHub Desktop.
Download ZIP
Force Drop Mysql Table - Bypassing foreign key constraint
Raw
force-drop-table-bypass-foreign-key.sql
SET foreign_key_checks = 0;
drop table TABLE_NAME
SET foreign_key_checks = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment