SQL

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/
Ebook Download
View all
Learn
View all
Membership not found