Home > Interview Questions > SQL Server > Difference between delete and truncate statements in sql server?

Difference between delete and truncate statements in sql server?

by Narain Siddharth   on 08/05/2011   Category: SQL Server   |  Level: Beginner   |  Views: 1167    |  Points: 25     |  Silver 


1. Truncate is faster than delete statement.
2. Delete is Data manipulation Language (DML) command and Truncate is Data Definition Language (DDL) command.
3. In Delete statement we can use with WHERE or without WHERE condition to delete a particular records but Truncate cannot, Truncate removes all the rows in the table.
4. Rollback is possible in Delete statement but not in truncate statement.
5. Delete cannot reset identity of the table but Truncate resets the identity of the table.
6. Trigger cannot execute on Truncate but trigger will execute when deleting a row.


« Extension of a web user control?
» Return datatype of IsPostback property in .NET
Post Question  |  Question Home

Recent Posts

User Responses


No response found, be the first to review this question.

Submit feedback about this code snippet

Please sign in to post feedback

Latest Posts