Foreign Key Problem

• rs

  SSCrazy

  Points: 2819

  More actions

  March 15, 2004 at 1:09 pm

  #82342

  Hi:

  I am wondering whether I can create a Foreign Key

  constraint on a column of a table in database A, which

  refences another table's column in a diffrent database B.

  I got the following error message.

  Cross-database foreign key references are not supported.

  Is there any thing that can be done to achieve this.

  Thanks for your input

• fhanlon

  SSChampion

  Points: 13131

  More actions

  March 15, 2004 at 2:12 pm

  #498832

  Cross-database referential integrity must be implemented through triggers.  Keep in mind what might happen if database B were down (for maintenance or some problem) while database A tried to check for data integrity.  Your trigger should deal with this.  If there is a really close relationship perhaps database A and B should be combined.

  Francis