Oninit cdi / Archive
Talk to an expert →

Foreign key in other db------WebKitFormBoundaryhc+

Posted in 2009

Topics: Triggers, Constraints & Referential Integrity

FERNANDO — — source: IIUG Forums & Mailing Lists

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

↪ replying to FERNANDO
Fernando — — source: IIUG Forums & Mailing Lists

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

↪ replying to Fernando
R Fo — — source: IIUG Forums & Mailing Lists

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

↪ replying to FERNANDO
Art Kagel — — source: IIUG Forums & Mailing Lists

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

Related threads