Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25590 Views
- I also Faced
- E-Mail Answers
Answer Posted / pankaj kumar upadhyay
1) When we use delete command that time we will use
conditon or without conditon but when we use truncate
command so that time we will not use condition.
2)delete can roll back but truncate is not rollback.
3)Truncate is faster compare delete command.
4)delete is DML command while Truncate is DDL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is view in sql?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Do you know sql server 2008 backup compression?
What is the recursive stored procedure in sql server?
How to create nested stored procedure?
How can I check if a view exists in a sql server database?
How self join is different from outer join?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is resource db in sql server?
explain declarative management framework (dmf) in sql server 2008?
What is a matrix in ssrs?
What is the difference between online clustering and Offline clustering?
Explain about Views?
What is not null constraint?
what's the difference between a primary key and a unique key? : Sql server database administration
