DIFFERENCE BETWEEN DROP AND TRUNCATE

DIFFERENCE BETWEEN DROP AND TRUNCATE IN SQL SERER

----- 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/