DIFFERENCE BETWEEN DROP AND TRUNCATE

Venkatesan Jayakantham
12y
5.6k
0
0

Blog

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