What is the difference between TRUNCATE and DELETE?
Respostas da entrevista
Sigiloso
7 de dez. de 2021
TRUCATE deletes all the records in the table while DELETE deletes those records which follows some condition.
Sigiloso
25 de mai. de 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