Drop table syntax. Drop sequence

PostreSQL tutorial – Drop Table

Drop postgresql sequence

Drop table if exists syntax. Drop sequence.

Syntax

DROP SEQUENCE [ IF EXISTS ] 
sequence_name [ CASCADE | RESTRICT ];

Example

DROP SEQUENCE sequence_name;

Drop postgresql table

Syntax

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

Example

Drop single table: 
DROP TABLE customers;

Drop more than one table: 
DROP TABLE customers, sales;

Create table |
Alter table