DELETE: Removes specific rows based on WHERE condition. Can be rolled back, triggers fire, slower for large datasets.
TRUNCATE: Removes all rows from table but keeps structure. Faster than DELETE, cannot be rolled back in most databases, doesn't fire triggers.
DROP: Completely removes the table structure and data from database. Cannot be rolled back.
DELETE FROM employees WHERE age > 65; -- Removes specific rows
TRUNCATE TABLE employees; -- Removes all rows, keeps table
DROP TABLE employees; -- Removes entire table
Rewriting in plainer words…
This answer doesn't lend itself to a diagram - it reads best . No credits were charged.
