What’s the difference between DELETE and TRUNCATE ?

Following are difference between them: 
=>>DELETE TABLE syntax logs the deletes thus making the delete operations low. 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. 
=>>DELETE table can have criteria while TRUNCATE can not. 
=>> TRUNCATE table can not have triggers.

asked Sep 13, 2013 in Database(DBMS) by rajesh
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.