DIFFERENCE BETWEEN DROP AND TRUNCATE


----- DIFF BETWEEN DROP AND TRUNCATE


1. DROP WILL REMOVE THE OBJECT WHERE ARE DELETE WILL REMOVE ONLY THE DATA DELETE WILL DELETE EACH RECORD
2. NO LOGGING IN TRUNCATE ... LOGGING WILL HAPPEN IN DROP STATEMENT

Cheers,
Venkatesan Prabu .J
Head -
www.kaashivinfotech.com
http://venkattechnicalblog.blogspot.com/
Ebook Download
View all
Learn
View all