SET FOREIGN_KEY_CHECKS = 0; DROP TABLE <table_name> -- if you want to later add or modify foreign keys SET FOREIGN_KEY_CHECKS = 1;