Whats Difference between DELETE and TRUNCATE Command in SQL Server?

Posted on Friday, 13 April 2012 by SQL Developer

DELETE and TRUNCATE are the commands used to solve one single purpose. That is to remove data from table.

Butt, there are few significant difference between DELETE and TRUNCATE Commands.

Here is the table which differentiate between DELETE and TRUNCATE Commands.