What Is The Difference Between Truncate And Delete Interms Of Referential Integrity

What Is The Difference Between Truncate And Delete Interms Of Referential Integrity


  • 22 Dec, 2011

    DELETE removes one or more records in a table, checking referential Constraints (to see if there are dependent child records) and firing any DELETE triggers. In the order you are deleting (child first then parent) There will be no problems.TRUNCATE removes ALL records in a table. It does not execute any triggers. Also, it only checks for the existence (and status) of another foreign key Pointing to the table. If one exists and is enabled, then you will get The following error. This is true even if you do the child tables first.ORA-02266: unique/primary keys in table referenced by enabled foreign keysYou should disable the foreign key constraints in the child tables before issuing the TRUNCATE command, then re-enable them afterwards.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.