METHOD AND SYSTEM FOR RE-POPULATION OF DATA IN A DATABASE

A method for automatic re-population of data in a database in response to detection of at least one script-transaction, the database includes a plurality of tables. The script-transaction is carried out in response to a script input. The method includes truncating at least one table, which is being modified by at least one of a persistent trigger and a non-persistent trigger. The persistent trigger updates a table and the non-persistent trigger performs one of an insert operation and a delete operation on a table. Further, the method includes executing a non-persistent trigger corresponding to each truncated table of the database in a predefined-update-sequence. Also, the method includes executing at least one persistent trigger corresponding to each truncated table of the database.