Posted on December 7, 2012October 10, 2018 by BradDropping or truncating tables with foreign key constraints in MySQL Just a quick tip, if you need to drop a lot of tables with foreign key constraints use: SET FOREIGN_KEY_CHECKS = 0;