Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22083 Views
- I also Faced
- E-Mail Answers
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
What is difference between delete and truncate commands?
What is the difference between stored procedure and user defined functions?
How to find Duplicate Records In table?
What is the sql case statement used for?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Can binary strings be used in arithmetical operations?
What causes index fragmentation?
Explain filestream storage of sql server 2008?
How do I completely remove sql server instance?
what are the important architecture components of SSRS?
How is table type constraint applied to a table?
Do you know how to make remote connection in database?
What is an index in sql?
what is the primary use of the model database? : Sql server administration
How do I change my passwords (database, LDAP, and so on) without causing an outage?
