Sunday, May 9, 2010

Difference between DELETE & TRUNCATE commands?

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 table can not trigger.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.