Unanswered: When does view DML trigger fire?
With a DML trigger on a table, if you make changes to the table, the trigger fires.
That's pretty straightforward.
Now, suppose the table does not have a trigger on it and I wrap the table in a view.
Then, I create a DML trigger on the view.
If I make changes through the view, it makes sense that the view trigger would execute.
My question is, if that view trigger exists, and I make changes directly to the table (not through the view) does the view trigger execute?
Will start experimenting on my own now, but just thought I would ask if anyone has direct knowledge of this functionality.
Maverick Software Design
(847) 864-3600 x2