drop-all-tables-with-no-root-access.sql

--------- RUN QUERY 1 ---------
-- Run this query to get SQL to drop each table

SELECT concat('DROP TABLE IF EXISTS ', table_name, ';') 
FROM information_schema.tables 
WHERE table_schema = 'database_name';

-- Copy results

--------- RUN QUERY 2 ---------

SET FOREIGN_KEY_CHECKS = 2;
--- PASTE HERE RESULTS
SET FOREIGN_KEY_CHECKS = 1;