Just a quick tip, if you need to drop a lot of tables with foreign key constraints use:

SET FOREIGN_KEY_CHECKS = 0;

DROP/TRUNCATE tables here..

SET FOREIGN_KEY_CHECKS = 1;