Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Managing columns that reference columns in other datases Expand / Collapse
Author
Message
Posted Friday, February 7, 2014 8:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:13 PM
Points: 48, Visits: 191
Hi,
I think there must be a standard practice how to a manage column (in actuality foreign keys) that reference a column in another database. In my case, I have an employee table in employee database. Other databases need to store employeeId that actually resides in employee.employee table. How do I manage this kind of relationship across databases?
I have several of such examples in the system and cannot think of a way to manage this thing. I will appreciate all the help.
Post #1539202
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse