|
I am creating a system where I have a trigger on
three different tables. There is a particular Boolean field in each of
these tables that when it is set in table it should be set the same in the
other two. So I figured I could put a trigger on each table that
when the Boolean field was updated it would go and update the other 2. However, I am concerned about cascading trigger
calls. Does anyone know if it is possible to run an update
statement on a table and for only that statement disable the trigger on the
table? |
