Subject | Retrieve name of table inside trigger |
---|---|
Author | Lee Jenkins |
Post date | 2009-12-26T16:54:24Z |
I want to log changes in certain tables to a change_log table inside the same
database and the SP logic, etc is no problem, but..and it seems this must be
obvious, but how can I determine the name of the table that a running trigger
applies to? I didn't see anything in the context variables available in 2.1,
but I could have missed it too.
Right now I'm just hard coding the trigger name to an SP call that logs the
changes, but it would be cleaner I think if I could
Thanks,
--
Warm Regards,
Lee
database and the SP logic, etc is no problem, but..and it seems this must be
obvious, but how can I determine the name of the table that a running trigger
applies to? I didn't see anything in the context variables available in 2.1,
but I could have missed it too.
Right now I'm just hard coding the trigger name to an SP call that logs the
changes, but it would be cleaner I think if I could
Thanks,
--
Warm Regards,
Lee