What is the difference between Truncate and Delete?
Delete statement removes rows of a table one by one & delete triggers on that table fires. But Truncate removes all rows by deallocating the data pages assigned to the table & only these deallocation are recorded in the transaction log.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment