Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 21263 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 create statement?
What is snapshot parameter in ssrs?
What is the difference between push and pull subscription? : sql server replication
What is buffer cash in sql server?
How to use user defined functions in expressions?
What is cross join in sql server joins?
What does normalization do to data?
What is the difference between online clustering and Offline clustering?
What is global temp table?
What are the steps to process a single select statement?
What is the maximum length of an alert name?
What is a View ? Can we insert, Update and delete a view?
Write a sql query to get zero records from a table having n number of records?
What are sp_configure commands and set commands?
What is resource governor in sql server?
