Re: Q. external database updates

On Wed, 29 Apr 1998 15:25:47 +0100, Pete Smith <pete.smith@aethos.co.uk> wrote: >Pete Smith wrote: > >> hi all >> >> I am trying to set up the following scenario: >> >> db 1 on instance a >> db 2 on instance b ( may be on the same or a different host ) >> >> I would like table x on db 2 to have a foreign key constraint >> referencing table y on db 1, >> is this possible? No, it's not with regular contraint definitions. Both tables must be in the same database. Sometimes it's a database design error when you think you need this. Other times it may have been nice to have it. It may be that it's possible to set up triggers and stored procedures to do it, but that may be to slow depending on your setup and what you want to do. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)