Below 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 |
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}