Subject Re: [firebird-support] Retrieve name of table inside trigger
Author Thomas Steinmaurer
Hi Lee,

> 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?

No way via context variables. You have to hard-code the table name
inside your trigger, which is usually done by the trigger code
generation facility, if you want to have that automated. ;-)

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
My blog: