Foreign key in other db------WebKitFormBoundaryhc+
Fernando asked whether a foreign key constraint can reference a synonym pointing to a table in another database. Fernando Nunes answered no, R Fo said constraints and triggers are only allowed on tables, and Art Kagel confirmed and suggested keeping a local copy synchronised by triggers or ER, then constraining that. He also pointed to the IIUG features survey.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi.. It´s possible to create a constraint from a synonym? I have a synonym that "points" to a table from other db. Can I create a foreign key constraint of that table/synonym? Thanks. ------WebKitFormBoundaryhc+PpaVmAs3TSkvi
No. Regards. On Mon, Sep 28, 2009 at 3:29 PM, <> wrote: > Hi.. > > It possible to create a constraint from a synonym? I have a synonym that > "points" to a table from other db. Can I create a foreign key constraint of > that table/synonym? > > Thanks. > ------WebKitFormBoundaryhc+PpaVmAs3TSkvi > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --000e0cd68d207071d40474a42634
Triggers, constranints, ecc... are now allowed in synonym or view ! Only in TABLE ... BR > To: ids@iiug.org > From: domusonline@gmail.com > Subject: Re: Foreign key in other db------WebKitFormBou.... [17217] > Date: Mon, 28 Sep 2009 10:31:18 -0400 > > No. > Regards. > > On Mon, Sep 28, 2009 at 3:29 PM, <> wrote: > > > Hi.. > > > > It possible to create a constraint from a synonym? I have a synonym that > > "points" to a table from other db. Can I create a foreign key constraint of > > that table/synonym? > > > > Thanks. > > ------WebKitFormBoundaryhc+PpaVmAs3TSkvi > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --000e0cd68d207071d40474a42634 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Windows Live: Keep your life in sync. Check it out! http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_012009
No, you cannot. You should take the IIUG Features survey that was announced a few days ago. One of the questions asks if having the ability to create foreign keys to other databases would be useful. What you can do is to duplicate the table in the local database and add triggers to the primary copy (or use ER if you are licensed for it) to keep this duplicate copy up-to-date. Then you can put the constraint on the local copy. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Sep 28, 2009 at 10:29 AM, <> wrote: > Hi.. > > It possible to create a constraint from a synonym? I have a synonym that > "points" to a table from other db. Can I create a foreign key constraint of > that table/synonym? > > Thanks. > ------WebKitFormBoundaryhc+PpaVmAs3TSkvi > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0023545bf54826294e0474adf293