| Truncate | Delete | 
| Truncate Table <Table   Name> | Delete from <Table Name> Where <Condition> | 
| Cannot use Where Condition | It is possible | 
| It Removes all the   data | It deletes specified data if where condition exists. | 
| Faster in performance   wise, because it doesn't keep any logs | Slower than truncate because, it keeps logs | 
| Rollback is not   possible | Rollback is possible | 
Search this blog
Wednesday, December 29, 2010
Truncate Vs Delete
Labels:
SQL,
SQL Server
Subscribe to:
Post Comments (Atom)
 
 
Hi Babu,
ReplyDeleteIts nice one, I think there is one more major difference.
Truncate will reset identity column in target table but delete will not.
thi is helep me thank for special
ReplyDelete