What are the Differences between TRUNCATE and Delete ?

Sno	TRUNCATE	DELETE
1	TRUNCATE is faster	Comparitively slower.
2	Removes all rows from a table	Can remove specific rows with Where clause
3	Can not be Rolled back.	Can be.
4	Is DDL Command.	Is DML Command.
5	Resets identity of the table.	Does not.
6	Removes the data by deallocating the data pages and logs the deallocation.	Removes one row at a time and records an entry in the transaction log for each deleted row.

www.codecollege.NET