Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18690 Views
- I also Faced
- E-Mail Answers
Answer Posted / satya
1.Both Truncate and Delete are rollbacked in TSQL.
2.Truncate maintains single record in Transaction log
entire records where Delete writes one-to-one record which
is slow in performance.
3.Truncate reinitializes the IDENTITY count to zero.
4.Truncate gives error with Table Variables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Do you know the cursor types?
Can you explain the disadvantages/limitation of the cursor?
What are secondary xml indexes?
Does full backup break log chain?
Do you know what is difference between index seek vs. Index scan?
How can I track the changes or identify the latest insert-update-delete from a table?
Will count(column) include columns with null values in its count?
How to use user defined functions in expressions?
How to execute a sql statement using odbc_exec()?
How to change the ownership of a schema in ms sql server?
Give me any three differences between Truncate and Delete.
What is the difference between system objects and user objects?
What is the difference between for trigger and after trigger?
Explain the difference between HTTP and HTTPS in database?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
