Databases · Junior · Question 34 of 75

What is the difference between `DELETE FROM logs` and `TRUNCATE logs`?

1TRUNCATE deletes only rows older than a day
✓Correct answer: TRUNCATE removes all rows at once, much faster, without scanning rows or firing row triggers
3DELETE removes the table itself

Explanation

DELETE can have a WHERE and removes rows one by one. DROP TABLE removes the table structure too.

Further reading

PostgreSQL: Tutorial - The SQL language ↗

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.