Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19112 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 happens if null values are involved in comparison operations?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is the stuff and how does it differ from the replace function?
What is the difference between inner join and equi join?
Which Model uses the SET concept
What are the hotfixes and patches in sql server?
last function used in MS Access to convert sql what function will use in sql
What are different types of table joins?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How to create new databases with "create database" statements?
What is function of ROLLUP ?
Write the syntax for stuff function in an sql server?
What is normalization? Explain different forms of normalization?
What are .mdf files?
What are the differences between ms sql server & oracle?
