> Hello!
> I would like to update a table in another schema in the same
database. This
> should be done through a trigger on Insert or Update. How do
I address the
> table in the other schema?
>
> Thanks for your help and advices.
Hi,
You should have no problem referring to the table in another
schema by using a "qualified" name in the code of the
trigger (e.g. update <schema2>.<table> set ...), provided
you have the rights to update the table of course.
Hope this helps.
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=4884&cus_id=USENET&qtn_id=3706
Received on Tue Oct 12 1999 - 06:24:01 CDT
