DbSchema Database Designer

DbSchema | How to Drop All Tables from PostgreSQL

Publish on DbSchema Blog >>>

1.Drop all tables by deleting the schema

This example will drop all tables from the public schema.


If you want to drop tables from another schema, replace public with the name of your schema.

The first statement will drop the current schema and the next one will create a new schema with the same name but without any table.

After executing the two queries, you may also want to restore the grants for the new schema. Do this by executing:

GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO schema_name;

2.Drop all tables without deleting the schema

    r RECORD;
    FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = current_schema()) LOOP
        EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.tablename) || ' CASCADE';
END $$;

3.Drop all tables from DbSchema

Using DbSchema you can drop all the tables from a PostgreSQL database simply by selecting all the tables from the left menu, right-clicking on them and select the ‘Drop’ option.


DbSchema is a visual diagram designer that allows you to edit & browse databases from an interactive diagram. Use powerful query tools to manage complex databases, export HTML5 documentation or work with the schema offline.

Download DbSchema for Free

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.