Can you tell me the difference between DELETE & TRUNCATE commands?
Dinesh Beniwal
Hi Praveen,
TRUNCATE is also rollback the data.But difference is TRUNCATE can't mantian the log.
TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server. DELETE is a DML command and can be rolled back. Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster.
More info at :
http://www.faqfarm.com/Q/How_do_you_differentiate_between_truncate_and_delete
http://www.geekinterview.com/question_details/425