I have tested this from both the DB Navigator as well as Toolbox -> DB Explorer
- Open an existing trigger
- Go to the ‘Columns’ Tab
- Select a column on which you want the trigger to fire.
- Apply the changes.
When I go back to the Columns Tab, the column I selected is there.
If I close the trigger and open it again OR extract the DDL the change is NOT there.
I got around this by:
- Execute step 1-4
- Make a change to the trigger body (just add a space)
- Clicked ‘Generate SQL for changes’
The SQL script generated, containted the “UPDATE OF column1” statement