What is the difference between TRUNCATE and DELETE?
Interview Answers
Anonymous
7 Dec 2021
TRUCATE deletes all the records in the table while DELETE deletes those records which follows some condition.
Anonymous
25 May 2023
When you “ delete “ for deleting all row then your identity value start from next number
When you use “truncate” for deleting all row then your Identity start from 1