Post reply

Foreign Key from one database to another

  • February 4, 2009 at 10:19 am

    #97102

    I have my membership info separate from my products / sales database.

    There are a few tables that I would like share related data; however, they are in different databases.

    Is it possible to do something like a Foreign Key from one database table to another.

    How do we link related data from one database to another. FK_ Constraint

    thanks

    Dam again!

  • February 4, 2009 at 10:42 am

    #938184

    Hi

    I am afraid foreign keys can only be applied within the same database. If you wish to enforce data integrity across databases then you will have to

    write your own logic. Normally I use insert/update triggers for this or write it within the stored procedures that add/update/delete the data.

    Regards

    Richard...

    http://www.linkedin.com/in/gbd77rc

  • February 4, 2009 at 10:45 am

    #938185

    OK,

    Thanks.

    Dam again!

  • February 4, 2009 at 12:01 pm

    #938269

    Search on Google. There are a couple of 3rd party utilities that make pseudo FK's that cross databases.

    Beware, you can do this with check constraints and/or triggers, but they always perform much more poorly than native FK relationships. You may find that it is better to allow your application to manage this data integrity if the tables are of significant size.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply