Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19035 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
Can you please explain the difference between primary keys and foreign keys?
What is store procedure?
Tell me about normalization in DBMS.
What are the properties of the transaction?
Why do we use stored procedures in sql server?
How to connect to a sql server using odbc_connect()?
What are logical/boolean operations in ms sql server?
What are parameterized reports?
Explain what is sql server english query?
What is the log shipping?
What does it mean if @@cursor_row returns a negative number?
What are extended events in sql server?
What is entity data services?
How to delete duplicate rows?
what are constraints? : Sql server database administration
