For training related to .net,OOPS,design patterns, MVC,WCF and .net fundamentals
contact at sukeshmarla@gmail.com or Click Here

Click here for my training feedbacks

Followers

Follow Us



Share your Interview questions here


For software development queries contact SukeshMarla@Gmail.com

Follow by Email

Learn everything about MSBI

02 January 2011

Truncate Vs Delete

TRUNCATE

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.


DELETE


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