drop all tables in database psql code example Example: force drop all tables postgres DROP SCHEMA public CASCADE; CREATE SCHEMA public;