Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18700 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
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Does sql server 2000 clustering support load balancing?
What is the difference between insensitive and scroll cursor?
What do you understand by hotfixes and patches in sql server?
What are the advantages of the mirroring?
What is use of except clause?
What command is used to create a database in the sql server and how?
What the different types of Replication and why are they used?
what is a join? : Sql server database administration
What is sql injection? How to protect against sql injection attack?
What is the difference between cartesian product and cross join?
Create and insert into temp table in sql server?
Why do we use functions?
Explain the steps to create and execute a user-defined function in the sql server?
What is a data collection table?
