Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19077 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 are truncate options available in sql server? : sql server database administration
What are the properties of sub-query?
What is sql server management studio? : sql server management studio
Explain transaction server implicit?
What is buffer cash and log cache in sql server?
what method you can use to reduce the overhead of Reporting Services data sources?
What is a ddl statement?
What is precedence constraint?
Differentiate between ms sql server reporting services vs crystal reports?
What is a hint?
What are the differences between ms sql server & oracle?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
How do you clear a log file?
How to count groups returned with the group by clause in ms sql server?
How to enable/disable indexes?
