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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Column List In Update Trigger

Status
Not open for further replies.

wildthing68

IS-IT--Management
Oct 17, 2006
2
GB
I want to create an audit trail system in my db but only on certain tables and columns. I know I can do:
IF UPDATE(col1)
.
.
IF UPDATE(col2)
.

etc, etc

what I whant to do is pull in the list of updated columns from the triggering command so I can use a table to control the auditted columns.

Does anyone know where this information is held?

Cheers

ps 11.9.2 on Linux
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top