DELETE TRUNCATE TABLE difference sql server
DELETE TABLE : Delete is done on row by row basis and it logs the transaction which is slow.
TRUNCATE TABLE : Deletes all the rows at a time which makes it faster.
TRUNCATE TABLE can be rolled back.
What’s the difference between DELETE and TRUNCATE TABLE statement? was last modified: October 1st, 2017 by