drop table postgresql code example

Example 1: force drop all tables postgres

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

Example 2: how to remove tables from postgresql

DROP TABLE IF EXISTS tablename;

Example 3: possgress drop if exists table

drop table if exists tableName

Example 4: postgresql drop table

DROP TABLE name;

Example 5: psql delete table

DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]