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
Do you know what are the ways available in sql server to execute sql statements?
What is an expensive query?
How do I find my localdb version?
Explain triggers in sql?
How to install sql server 2005 express edition?
How to retrieve error messages using odbc_errormsg()?
List out the different types of locks available in sql server?
Can we use max in where clause?
Explain the concept of view and Types of views in SQL server?
What is difference between delete and truncate commands?
How to use transact-sql statements to access the database engine?
How do I find sql server instance name?
What do you understand by hotfixes and patches in sql server?
How do I port a number to sql server?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?