What's the difference between DELETE TABLE and TRUNCATE TABLE commands? Dot Net Interview Questions

punjabtechnicaluniversity.blogspot.in


Following are difference between them :-

1. DELETE TABLE syntax logs the deletes thus making the delete operation slow.TRUNCATE table does not log any information but it logs information about deallocation of data page of the table.So TRUNCATE table is faster as compared to delete table.

2. DELETE table can be rolled back while TRUNCATE can not be.

3. DELETE table can have criteria while TRUNCATE can not.

4. TRUNCATE table can not triggers.