Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19356 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
Define outer join?
Explain what is the main purpose of having conversation group?
What are the results of running this script?
What is a mixed extent?
what is the difference between openrowset and openquery?
Explain Reporting Life Cycle?
What is normalization and its types?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What are commonly used mssql functions in php?
Explain what is raid and what are different types of raid levels?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
what is a live lock? : Sql server database administration
What does it mean to invest in the index?
What is meant by dirty read?
