DROP TABLE

Drop a table from the database.

DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
IF EXISTS
Do not return a warning if the table does not exist.
name
Name the table to drop, optionally qualified by its schema name. You can drop multiple tables with one statement.
CASCADE
If other objects depend on the table, such as other tables or views, drop them as well.
RESTRICT
If other objects depend on the table, do not drop the table. This is the default.
For example, drop three tables with one statement:
premdb=# drop table awayteam, hometeam, team;
DROP TABLE
Attempt to drop a table with a dependent view:
premdb=# drop table season;
ERROR:  cannot drop table season because other objects depend on it
DETAIL:  view teamview depends on table season
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
Use the CASCADE option to drop the table and the view:
premdb=# drop table season cascade;
DROP TABLE