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.