Thursday, June 11, 2009

Differentiate between TRUNCATE and DELETE.

Differentiate between TRUNCATE and DELETE.
The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data

0 comments:

Post a Comment