Truncate vs Delete in DataBase Table

This explains the major differences between Truncate and Delete statements in Databases like Oracle, SQL Server.

Following are the major differences between Truncate and Delete statements:

1) Once you issue TRUNCATE statement, it cannot be rolled back where as DELETE statement has the option of rollback.
2) TRUNCATE resets the identity of the table where as DELETE does not reset the same.
3) TRUNCATE is a DDL Command where as DELETE is a DML Command.
4) One could not issue TRUNCATE statement on a table referenced by a Foreign Key constraint where as DELETE statement can be issues to the table referenced by a Foreign Key constraint.
5) TRUNCATE statement executes faster and uses less resources of transaction log where as DELETE statement is slow as it deletes rows one by one and for each record an entry is made in transaction log thereby increasing resources.
6) TRUNCATE statement removes the data and deallocates the data pages used to store the table’s data where as DELETE statement does not remove data pages and identity counters remain.
7) TRUNCATE removes all the rows of the table but not the table structure, columns, constraints, indexes. We could use WHERE clause in DELETE but not in TRUNCATE statement.
8) TRUNCATE statement could not activate triggers where as DELETE statement could activate triggers.