Thursday, May 15, 2008

Truncate and Delete

TRUNCATE does not records the transactions that delete the rows from a table thus it will not be recoverable if thr transaction is rolled back.DELETE on the other hand recods the transactions and hence rows deleted can be recovered if rolled back before committing the transaction.

No comments:

Post a Comment