PostgreSQL Delete Table

The drop TABLE statement for PostgreSQL is used to delete the index, rules, triggers, and constraints of the table definition and all its related data tables.

You must use this command with caution, because once a table is deleted all the information provided in the table will be lost forever.

Grammar:

The basic syntax for the DROP table statement is as follows.

DROP TABLE table_name;

Instance:
Suppose there is already a student table, and now we delete it.

First we look at the tables in the database

Then execute the Delete command

Check again to see  that there are no student tables in the Discovery database

PostgreSQL Delete Table