What is the difference between TRUNCATE and DELETE?
Interview Answers
Anonymous
Dec 7, 2021
TRUCATE deletes all the records in the table while DELETE deletes those records which follows some condition.
Anonymous
May 25, 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