Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Programatically Determing Table Name from Trigger

Status
Not open for further replies.

gaffonso

Programmer
Jul 26, 2001
25
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top