What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 20198 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
How do I start sql server 2016?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
How to filter records of table in SQL SERVER?
What is transact-sql language?
Define synonym?
Do you know what are the differences between lost updates and uncommitted dependencies?
Why de-normalization required?
What do we have to check in database testing?
What do you do in data exploration
What are the filtered indexes?
How to write a query with an inner join in ms sql server?
What is the difference between osql and query analyzer?
What do you understand by coalesce in sql server?
What is a full text index?
How do I edit a stored procedure in sql server?
