DROP TABLE

DROP TABLE completely removes a table and all its data. Cannot be undone (except from backups).

Add `IF EXISTS` to avoid an error if the table isn't there.

Example 1 (sql)

DROP TABLE IF EXISTS old_users;

Output

Table dropped

Safe drop.

Example 2 (sql)

DROP TABLE users CASCADE;

Output

Table + dependent objects dropped

CASCADE drops dependent objects (views, foreign keys) — use with care.

Key points

💡 Note: TRUNCATE keeps the table but wipes rows. DROP removes the table itself.