What are 2 differences between delete and truncate?

Delete vs Truncate
SQL DeleteSQL Truncate
It removes rows one at a time.It removes all rows in a table by deallocating the pages that are used to store the table data
It retains the identity and does not reset it to the seed value.Truncate command reset the identity to its seed value.

Related posts: