Foreign Key to a different database on same server

• robby_disco

  SSC Veteran

  Points: 249

  More actions

  April 12, 2002 at 8:35 am

  #78385

  I'm wondering if it is possible to create a Foreign Key to a different database on the same server? Essentially we have a "master client" database that we use as a repository for limited information that we pull from client db's. Can I FK from a client db table to a field in a table thats in the "client master"?

  Example:

  Master_Client..client

  ------------------

  ID Client type ...

  1 JJ 3

  2 RR 2

  Client1..store

  ------------------

  ID Name ClientId

  1 5th St. 1

  Client2..store

  ------------------

  ID Name ClientId

  1 Disco St. 2

  Can I FK Client1..store or Client2..store to Master_Client..client??

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 12, 2002 at 8:56 am

  #427119

  DO not find anyway this is possible. However you may be able to enforce with a trigger.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)