Ajeet Mishra
What is the difference between Delete and a Truncate ?
By Ajeet Mishra in SQL Server on Sep 08 2015
  • Mukesh Kumar
    Sep, 2017 3

    delete is partialy deletion but truncate delets with magic table also

    • 0
  • Venkatesan M
    Jun, 2016 28

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

    • 0
  • Ajeet Mishra
    Sep, 2015 8

    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

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS