What is the difference between delete and truncate in SQL?

Question

Can anyone tell me the differences between delete and truncate in SQL?

Answer 1

DELETE is A DML command that is used to delete specific data. Truncate is a DDL command that is used to delete entire data of the table. So, we can use where clause in DELETE but not in TRUNCATE command. The changes made from DELETE command can be rolled back but cannot rollback from TRUNCATE. In comparison to performance, Truncate is faster than delete command.

The difference between Truncate and delete commands is the most frequent question in SQL interviews. I recommend to check out this SQL interview questions blog by Intellipaat for more such FAQs in SQL interviews.