3
Reply

What is the difference between Delete and a Truncate ?

Ajeet Mishra

Ajeet Mishra

9y
628
0
Reply

    delete is partialy deletion but truncate delets with magic table also

    when use delete cannot recreate deleted data.it is slowuse truncate can recreate .it is fast

    Delete Does not reset the identity of the table Its DML Command It can be rolled back Its Slower (Removes row one by one) WHERE Condition can be used Records entry in transaction log for each deleted row Trigger can be activatedTruncate Resets identity of the table Its DDL Command It cannot be rolled back Its Faster (Uses Fewer systems) WHERE Condition can't be used Removes the data by de-allocating the data pages Trigger can't be activated