Kuldeep's blog
Difference between Delete and Truncate
Submitted by Kuldeep on Sat, 02/19/2011 - 00:22Removing records from a table is a crucial operation. So I would like to pen down my knowledge about removing records from a table. There are two ways to do the same, Truncate and Delete.
I would like to explain the basic difference between two.
1. Delete is a DML whereas truncate is a DDL. Truncate deallocates the data pages for the table and does'nt delete them row by row. So if there is an Identity column in the table it would be reset to initial seed after truncate.
