What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 18982 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
What will be query used to get the list of triggers in a database?
How sql server enhances scalability of the database system?
What is the purpose of indexing?
What is a hint?
How to enforce security in sql server? : sql server security
What are the operating modes in which database mirroring runs?
How do I know if localdb is running?
Explain triggers in sql?
Can a table be created inside a trigger?
Do you know how to make remote connection in database?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is collation sensitivity? Explain different types.
Difference between drill down and drill through report.
what is bit datatype? : Sql server database administration
What is query optimizer in sql server?
