Difference between Truncate and Delete

Difference between Truncate and Delete

----- DIFF BETWEEN TRUNCATE AND DELETE

1. TRUNCATE WILL DELETE THE ENTIRE TABLE @ A STRETCH  DELETE WILL DELETE EACH RECORD
2. NO LOGGING IN TRUNCATE ... LOGGING DELETE
3. PROCESS IS TOO FAST AND WE CAN RECOVER THE DATA IN TRUNCATE

Cheers,
Venkatesan Prabu .J
Head - www.kaashivinfotech.com
http://venkattechnicalblog.blogspot.com/