Re: Update a table in another schema through a trigger

> 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?

By issuing e.g. UPDATE <schema name>.<table name> SET <column name> = <value>, for example UPDATE user1.table1 SET column1=1;

Brian Received on Wed Sep 29 1999 - 07:15:37 CDT