Answers

Question and Answer:

  Home  Basic SQL Server

⟩ Please differentiate between DELETE and TRUNCATE?

- 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.

 138 views

More Questions for you: