PostgreSQL Drop Table

PostgreSQL Drop Table

The PostgreSQL DROP TABLE is used to delete a table from a database.

Drop Table syntax

DROP TABLE [ IF EXISTS ] 
table_name [ CASCADE | RESTRICT ];

Drop Table example

CREATE TABLE my_goods
(
ID INT,
NAME VARCHAR(150),
G_TYPE VARCHAR(10)
);

DROP TABLE IF EXISTS my_goods;