Hello,

I want to find the columns which execute updatetriggers. Is there in sabyase a way to find out?

In Oracle you can say:

SELECT COLUMN_NAME
FROM DBA_TRIGGER_COLS
WHERE TRIGGER_OWNER = 'MyOwner'
AND TRIGGER_NAME = 'JobUpdate'
AND TABLE_NAME = 'Job'
AND COLUMN_LIST = 'YES'

The following is not good enough:
SELECT TRIGDEFN
FROM SYS.SYSTRIGGERS
WHERE OWNER = 'DBA'

Can anybody help?

thanx and greetz

C Dunnink
The Netherlands