Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24934 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 stored procedure would you use to view lock information? : Sql server administration
What is store procedure? How do they work?
What is the most common type of join?
What is Lock table in SQL?
What is log cache in sql server?
what is a deadlock? : Sql server database administration
Why we use trigger in sql server with example?
What are the differences between stored procedure and the dynamic sql?
What is the sql case statement used for? Explain with an example?
How dts is used to extract, transform and consolidate data?
What is the difference between varchar and nvarchar?
Explain transaction server implicit?
What Are the Main Features of SQL Azure?
How to get the definition of a trigger back?
What is GUID in sql server?
