Ok, this is a weird one …
I have two tables …
In “Table”, I have a trigger … “tri_table_audit”. This trigger fires on every INSERT and DELETE statement on “table”. It then, inserts a copy of the new data into the audit table. BTW: Both “table” and “tableAudit” contain the same fields.
Now, when I go an generate the DDL SQL script. It will first create the “table”, then the triggers, then “tableAudit”. The problem with this order is, the trigger is created with compilation errors, since tableAudit does not exist at that time.
Is there any way to have triggers created after it’s dependencies are created? Or am I doing this all wrong?