Skip to content
masterclass Buddy
Start learning

PostgreSQL · Command

DROP TABLE

DROP TABLE removes one or more tables from PostgreSQL. Use IF EXISTS to avoid an error for a missing table; RESTRICT is the default dependency behavior.

Last updated

Syntax

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

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • ALTER TABLE
  • CREATE TABLE
  • DELETE
  • TRUNCATE

Source: PostgreSQL: Documentation: 18: DROP TABLE. Checked 2026-11-03.