What is the difference between Delete and a Truncate ?
Ajeet Mishra
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