What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
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 partition in sql server?
Can I use sql azure as a backup with log shipping or database mirroring?
What types of Joins are possible with Sql Server?
what is an index? : Sql server database administration
Can we perform backup restore operation on tempdb?
Can we update data in a view?
How can I tell if sql server is 32 or 64 bit?
Can we add an identity column to decimal datatype?
Do you know what are the differences between lost updates and uncommitted dependencies?
Does full backup break log chain?
A trigger can reference objects outside the current database? State true or false.
Which language is supported by sql server?
What is model database? : SQL Server Architecture
What is order of B+tree?
Explain what is the difference between union and union all?