mysql drop all tables

SET FOREIGN_KEY_CHECKS = 0;
-- Your semicolon separated list of DROP statements here
SELECT concat('DROP TABLE IF EXISTS ', TABLE_NAME, ';')
FROM information_schema.tables
WHERE table_schema = 'taylorwessing';
SET FOREIGN_KEY_CHECKS = 1;