Delete and Truncate

Question

Delete can be rolled back but Truncate cannot be rolled back. Begin Transaction Delete Del_Details Rollback and i'm getting my deleted records but still when i use .... Begin Transaction Truncate Table Del_Details Rollback This command is also giving me my deleted records.. So where is the difference between Delete and Truncate in respect of Rollback.......Plz explain

Manoj Bisht · Answer

Thnx Kiran......

Kiran · Answer

Delete and Truncate both can be rollbacked. There is no difference between them as far as rollback perspective but there are other differences. Truncate is faster and will reset any identity columns to the default seed value. You cannot TRUNCATE a table that has any foreign key constraints. You will have to remove the contraints TRUNCATE the table and reapply the contraints.