Difference between DELETE and TRUNCATE command in SQL Server
Below are few points that differentiate the DELETE and TRUNCATE command.
|1||This removes the rows one at a time and then records it in the transaction log for each of those deleted row.||This used fewer transaction log than delete and is faster|
|2||This can be used with or without a Where clause||This removes all rows from a table|
|3||Can be rolled back.||Cannot be rolled back|
|4||It is a DML Command.||It is a DDL Command.|
|5||When an Identity is used , it is not reset||Identity is reset|
(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)