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.
TRUNCATE : You can't use WHERE clause
DELETE : You can use WHERE clause
August 07, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment