3
Reply

What is the difference between Delete and a Truncate ?

Ajeet Mishra

Ajeet Mishra

Sep 08, 2015
611
0

    delete is partialy deletion but truncate delets with magic table also

    Mukesh Kumar
    September 03, 2017
    0

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

    Venkatesan M
    June 28, 2016
    0

    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

    Ajeet Mishra
    September 08, 2015
    0