Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11994 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / prabhanjan
1)Truncate will perform faster then delete.
2)When we truncate table triggers will not fire on delete
event.Where as for delete triggers will fire
3)After truncate table we can't roll back.
But for Delete we can roll back
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the candidate key used for?
What is ole db used for?
What happens when shared and exclusive locks are applied on data item?
What is a Database?
Can a database table exist without a primary key?
What do you mean by database?
What is the difference between data source and database?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
Explain natural key?
What is aws documentdb?
How to shrink a database?
How do I setup a database connection?
How many types of normalization? What is the use of it?
Explain buffer manager?
How to do Data integrity testing? Who does this testing (Developer or tester)?
