mediumDSA

What is the difference between DELETE, TRUNCATE, and DROP?

Q: What is the difference between DELETE, TRUNCATE, and DROP?

**DELETE** removes selected rows (with WHERE), is logged, and can be rolled back. **TRUNCATE** quickly removes all rows, resets identity, minimal logging, can't use WHERE. **DROP** removes the entire table (structure and data).

207 views

Understand the problem

Compare DELETE, TRUNCATE, and DROP.

delete-truncate-drop

Attempt it yourself

Sketch your approach before reading the solution — that's what interviews test.

Nudge consolestandby

Stuck? Beam a request up — the console returns a conceptual nudge that guides your logic without spoiling the implementation.

Study the solution

DELETE removes selected rows (with WHERE), is logged, and can be rolled back. TRUNCATE quickly removes all rows, resets identity, minimal logging, can't use WHERE. DROP removes the entire table (structure and data).

Solution ready — 2 min read

Classified // press E to declassify

Run the code

SQLDelete vs Truncate Playground

Join the discussion

Discussion (0)

No responses yet. Be the first to share what you think.

Transmission complete // awaiting log

KEEP THE
STREAK ALIVE.

Dossier 43 of 70 decoded in the SQL track. One more won't hurt.

Back to track

Next up→

Transaction isolation levels in Postgres — what anomalies does each level prevent?

Continue