mirror of
https://github.com/supabase/supabase.git
synced 2026-10-12 12:55:06 +03:00
CharisandChris Chinchilla
47705a8968
* fix: rewrite relative URLs when syncing to GitHub discussion Relative URLs back to supabse.com won't work in GitHub discussions, so rewrite them back to absolute URLs starting with https://supabase.com * fix: replace all supabase urls with relative urls * chore: add linting for relative urls * chore: bump linter version * Prettier --------- Co-authored-by: Chris Chinchilla <chris.ward@supabase.io>
29 lines
1.1 KiB
Plaintext
29 lines
1.1 KiB
Plaintext
---
|
|
title: 'Drop all tables in a PostgreSQL schema'
|
|
description: 'Useful snippet for deleting all tables in a given schema'
|
|
footerHelpType: 'postgres'
|
|
---
|
|
|
|
Execute the following query to drop all tables in a given schema.
|
|
Replace `my-schema-name` with the name of your schema. In Supabase, the default schema is `public`.
|
|
|
|
<Admonition type="caution">
|
|
|
|
This deletes all tables and their associated data. Ensure you have a recent [backup](/docs/guides/platform/backups) before proceeding.
|
|
|
|
</Admonition>
|
|
|
|
```sql
|
|
do $$ declare
|
|
r record;
|
|
begin
|
|
for r in (select tablename from pg_tables where schemaname = 'my-schema-name') loop
|
|
execute 'drop table if exists ' || quote_ident(r.tablename) || ' cascade';
|
|
end loop;
|
|
end $$;
|
|
```
|
|
|
|
This query works by listing out all the tables in the given schema and then executing a `drop table` for each (hence the `for... loop`).
|
|
|
|
You can run this query using the [SQL Editor](/dashboard/project/_/sql) in the Supabase Dashboard, or via `psql` if you're [connecting directly to the database](/docs/guides/database/connecting-to-postgres#direct-connections).
|