Home » RDBMS Server » Server Administration » Audit column names in trigger
Audit column names in trigger [message #370943] Fri, 10 March 2000 09:05
Bernhard Zengerle
Messages: 1
Registered: March 2000
Junior Member
following problem:
I'd like to create an update trigger that audits any actions on a certain table (option: for each row).
However the trigger should access the following information items :
- table name (could be hard coded - no problem)
- old value (no problem)
- new value (also no problem)
- column name (target of update action -> BIG PROBLEM!!!!)

I don't want to use any old vs. new string concatenation followed by analysing, what has changed (table contains more than 100 cols and I'm too lazy to create such a string)

any suggestions?????????
Previous Topic: Group By
Next Topic: Free Blocks
Goto Forum:
  


Current Time: Thu Oct 22 04:37:10 CDT 2020