What Is The Difference Between TRUNCATE And DELETE Commands

What Is The Difference Between TRUNCATE And DELETE Commands


  • 3 Jul, 2013

    both the functions prform the same operation but the truncate operations cannot be rolled back

    Comments Received:
    Please give your suggestions and feedback:
  • 16 Jul, 2012

    Delete is for Deleting the Data in the logical object  here there might be some filtering criteria in the Delete selection.

    Truncate will delete the Data and structure and Data also from the table so once the Structure is Delete if u are performing the Rollback is meaning less.

    Comments Received:
    Please give your suggestions and feedback:
  • 20 Mar, 2012

    TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.