Search This Blog

Sunday 13 April 2014

What is difference between TRUNCATE and DELETE?

What is difference between TRUNCATE and DELETE?

TRUNCATE
1. Truncate is a DDL command
2. We can remove bulk amount of records at a time
3. We can't rollback the records
4. Release the space in database
5. Truncate reset the high water mark
6. Truncate explicitly commit
                                                 DELETE
                                                 1. Delete is a DML command
                                                 2. We can delete record by record
                                                 3. We can rollback the records
                                                 4. Can’t release the memory in database
                                                 5. Delete can’t reset the water mark
                                                 6. Delete implicitly commit

No comments:

Post a Comment