⚠️ this sql query truncates all tables in the current schema (only tested in postgres) ⚠️

truncate.sql

// this is dangerous, use with care, it truncates all tables in the current schema
DO $$ DECLARE
    r RECORD;
BEGIN
    FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = current_schema()) LOOP
        EXECUTE 'TRUNCATE TABLE ' || quote_ident(r.tablename) || ' CASCADE';
    END LOOP;
END $$;