02 January 2011

Truncate Vs Delete


1. It is DDL Statement.
2. Faster in performance wise, because it doesn't keep any logs
3. Resets the Identity Column
4. Roll Back is not possible.
5. Can not use where clause
6. This operation will cause all DELETE triggers on the table to fire.


1. It is a DML Statement
2. Slower than truncate because, it keeps logs
3. Delete retains the identity counter means it will not reset.
4. We can rollback .
5. User Where Clause
6. no triggers will be fired

No comments:

Post a Comment

Your comments, Feedbacks and Suggestions are very much valuable to me :)

Things are upgraded

My Dear readers, I am really thankful for being supportive all these years. This site was the first blog site I ever created in my life...