What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 17344 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajay
DELETE Command
•It will delete record by record
•Execution is slow
•It is a logged command, so data
can be Restore after delete
•Condition can be applied with delete.
•It will fire trigger.
TRUNCATE Command
•It will delete all the records at the Same time.
•Execution is fast.
•It is not a logged command, so data can’t
be Restore after Truncate.
•Condition can’t be applied.
•It will not fire the trigger.
ajay.thomala@gmail.com
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is auditing in sql server?
What are pages and extents? : SQL Server Architecture
What is page-level compression?
Can we insert data into view sql server?
What is default constraint in ms sql server?
How to list all login names on the ms sql server?
Which are the new data types introduced in sql server 2008?
What is a collation in ms sql server?
Explain having clause and where clause?
What are the five characteristics of good data?
Explain iaas, paas and saas?
How to write a query with a full outer join in ms sql server?
What is the latest version of microsoft sql server?
What are the types of lock supported by ?
What is Replication?
