Thread
:
Best approach to relating databases or tables?
View Single Post
#
2
(
permalink
)
02-08-10, 08:24
r937
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
r937
View Public Profile
Visit r937's homepage!
Find all posts by r937