SQL Database Concepts Interview Question:

Please differentiate between DELETE and TRUNCATE?

Submitted by: Administrator

- Truncate can not be rolled back while Delete can be.
- Truncate keeps the lock on table while Delete keeps the lock on each row.
- Truncate resets the counter of the Identity column while Delete doesn't do so.
- Trigger is not fired in Truncate while it happens in Delete.
Submitted by: Administrator