View Single Post
  #2 (permalink)  
Old 02-08-10, 08:24
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
i would leave them in the same database

i'm not sure you can even declare a foreign key across databases -- you might want to set up a quick test to confirm/deny this
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote