Differences between Delete command and Truncate Command:
DELETE Command
(i) Delete command deletes all or particular Records
(ii) Delete will not release memory.
(iii) In delete, restoring is possible.
(iv) Delete will not reset identity
TRUNCATE Command
(i) Truncate deletes only all records.
(ii) Truncate releases memory.
(iii) Truncate restoring is not possible.
(iv) Truncate will reset identity.