DEV Community

01kg
01kg

Posted on

Supabase | How to delete all tables in "public" schema

TL;DR:

-- Drop all tables in a PostgreSQL schema (here is 'public' schema)
-- REF: https://supabase.com/docs/guides/database/postgres/dropping-all-tables-in-schema
do $$ declare
    r record;
begin
    for r in (select tablename from pg_tables where schemaname = 'public') loop
        execute 'drop table if exists ' || quote_ident(r.tablename) || ' cascade';
    end loop;
end $$;

Enter fullscreen mode Exit fullscreen mode

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More