Genpact Interview Question

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