What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 18940 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 does ss stand for sexually?
What are the advantages of having an index on the sql server?
Define inner join in sql server joins?
What is normalization and denormalization in sql server?
Can sql server be linked with other servers like oracle?
Explain about unique identifier data type in sql server?
What is difference between aggregate and analytic function?
What is cube dimension? : sql server analysis services, ssas
Tell about MOM Tool(Microsoft Operator Manager)?
Define Unique Key?
What is store procedure? How do they work?
What is ssrs?
What is buffer cash and log cache in sql server?
How raid can influence database performance?
Is t sql the same as sql server?
