What is the difference between TRUNCATE and DELETE?
Respuestas de entrevistas
Anónimo
7 dic 2021
TRUCATE deletes all the records in the table while DELETE deletes those records which follows some condition.
Anónimo
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