Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24475 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 index and primary key?
What is a matrix in ssrs?
How does the report manager work in SSRS?
What is the difference between Clustered and Non-Clustered Index?
How will you decide the active and passive nodes?
What are the character string functions supported by sql server 2005?
Call by value and call by reference in procedure and function, with NOCOPY.
What are triggers in ms sql server?
How do I find information about the install locations for the various instances running on a computer?
According to you what goes into making the best database administrator? : sql server database administration
Explain the advantages of merge replication?
Tell me extended events in sql server 2008?
Explain the properties of the relational tables?
List the ways in which dynamic sql can be executed?
What are the different types of data sources in ssrs?
