What is the difference between DELETE TABLE and TRUNCATE TABLE commands?
Following are differences between delete & truncate commands:-
1)The DELETE TABLE syntax logs the deletes thus make the delete operation slow. The TRUNCATE table does not log any information but it logs information about deallocation of the data page of the table so TRUNCATE table is faster while the delete table is not fast.
2) The DELETE table can have criteria while TRUNCATE cannot.
3) The TRUNCATE table cannot trigger.