In my quest to write a "global" audit trigger (one that does not contain any table-specific code), I need to determine the name of the table that fired my trigger programatically.
In my audit code, I log the table name being modified. Without a way to determine that name programatically the audit code for all the triggers has to set the table name by-hand and each trigger is slightly different.
Is there any way to determine the name of the table programatically?
Thanks!
- Gary
In my audit code, I log the table name being modified. Without a way to determine that name programatically the audit code for all the triggers has to set the table name by-hand and each trigger is slightly different.
Is there any way to determine the name of the table programatically?
Thanks!
- Gary