Possible Duplicate:
foreign keys on table from different database
I just wanted to know whether there is any way of creating a foreign key reference on a column on a database table to another column of a different database table (Cross DB)
Asked
Active
Viewed 147 times
0
Community
- 1
- 1
Running Rabbit
- 2,432
- 15
- 42
- 65
-
1Have a look at this thread : http://stackoverflow.com/a/1429473/971693 – Yan Brunet Jan 21 '13 at 14:18
-
Also see: http://stackoverflow.com/q/4452132/44522 and http://stackoverflow.com/q/265921/44522 – MicSim Jan 21 '13 at 14:20
1 Answers
0
No, you cannot implement a foreign key across databases.
You could use a trigger to enforce a constraint, but be aware that triggers can be disabled and there are also scenarios where they won't fire.
Aaron Bertrand
- 261,961
- 36
- 448
- 471