GilaMonster (1/15/2008)
If you update a view, the table underlying that view is updated. You shouldn't need a trigger.
Gail is of course right :). If you just want to have an extra level of indirection, and let people modify the underlying table of your view, you can do it via the view updating. The trigger is useful more for introducing extra constraints, like what columns and in what way you allow to modify.
Regards,
Andras