Sunday 2 October 2011

What is the difference between DELETE TABLE and TRUNCATE TABLE 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 : You can't use WHERE clause 
DELETE : You can use WHERE clause

No comments:

Post a Comment