Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22940 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 is named query? : sql server analysis services, ssas
What is the library index called?
What is mssql?
What is the command dbcc checkdb used for?
What do you mean by table and field in sql?
How is sql server used?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is a sql join?
What is the data tier application?
Why main is user defined function?
What are different type of Collation Sensitivity?
How to find related tables in sql server?
What is policy management?
What is an identity?
