PostgreSQL Drop Table

In this article, we will see how to drop PostgreSQL Table. DROP TABLE command removes tables from the database. Only the table owner, the schema owner, and superuser can drop a table.

PostgreSQL Drop Table

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

PostgreSQL Drop Table Examples:

1. DROP single table.

drop table test;

2. DROP multiple tables.

drop table sales,account;

To empty a table of rows without destroying the table, use DELETE or TRUNCATE. So, we have covered how to drop table in PostgreSQL.