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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment