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