Can you tell me the difference between DELETE & TRUNCATE
commands?
Answer Posted / rahul goel
There are many differences. Some of these are as follows:
1. Delete can be rollback but Turncate can not be rollback.
2. Delete is a DML command and Turncate is a DDL command.
3. Delete command is used for deleting one or more row from
the table whereas Turncate command is used for deleting all
rows from the table.
4. Turncate is fact as compared to delete command.
5. we can use where clause with Delete but where is not
possible with Turncate.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to create a store procedure with encryption?
Explain something about security and SQL Azure?
What is page-level compression?
What is the difference between indexing and hashing?
What is ms sql server index?
What are the extra roles available in msdb? : sql server security
How to attach adventureworkslt physical files to the server?
Explain the difference between delete,drop and truncate in SQL Server?
Explain about analysis services?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Do you know what is rank function?
Explain following error properties?
What is resultset concur_updatable?
What are the different types of collation sensitivity?
What is key set driven?