Differences between Delete command and Truncate Command – SQL Server Tutorial

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.

Related Projects

Leave a Reply

Your email address will not be published. Required fields are marked *