Drop all tables in a PostgreSQL schema
Sometimes it is required to just drop all tables of a specific schema in PostgreSQL. In order to delete the whole schema, execute the below command in the SQL query console.
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
This helps to delete tables that are, for instance, not deleted during an auto creation of the schema using Hibernate.