Differance between Truncate and Delete

Truncate

1) Delete all rows.
2) Identity counter retain.
3) Don't make entry to transaction log. therefore it is faster.
4) DDL command.
5) can not rollback
6) do not activate trigger.

Delete

1) Delete 1 or more row depend on where clause.
2) retain Identity counter.
3) Make entery to transaction log. so it is slower.
4) DML command.
5) Can be rollback.
6) Activate trigger.

0 comments: