What Is Difference Between TRUNCATE & DELETE

What Is Difference Between TRUNCATE & DELETE


  • 19 Feb, 2012

    TRUNCATE commits after deleting entire table i.e., cannot be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.