Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22418 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / archana motagi
Both the operations can be rolled back.The difference is,
DELETE TABLE is a logged operation, so the deletion of each
row gets
logged in the transaction log, which makes it slow.
TRUNCATE TABLE
also deletes all the rows in a table, but it won't log the
deletion of
each row, instead it logs the deallocation of the data
pages of the
table, which makes it faster.
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
Define self join in sql server joins?
What is user-defined multi-statement table-valued function?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
How to use "begin ... End" statement structures in ms sql server?
What is difference between inner join and join?
Is INSTEAD OF trigger directly applicable to Table ?
Why I am getting this error when dropping a database in ms sql server?
Explain the stored procedure?
Give me any three differences between Truncate and Delete.
Explain different types of lock modes in sql server 2000?
What are the difference between clustered and a non-clustered index?
How do you manipulate data?
What is an expression in ms sql server?
State the difference between union and union all?
What is difference between count (*) and count column?
