Difference between DELETE and TRUNCATE command in SQL Server
Join the DZone community and get the full member experience.
Join For FreeBelow are few points that differentiate the DELETE and TRUNCATE command.
| Sl. No. |
DELETE |
TRUNCATE |
| 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 |
Command (computing)
Truncate (SQL)
sql
Published at DZone with permission of Senthil Kumar, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
Comments