Skip to content Skip to sidebar Skip to footer

How To Make Foreign Key Relationship On Physically Distributed Data?

three servers server 1 is central point which links the other two servers. the other two servers have a table which has a field which should act like a foreign key problem well i

Solution 1:

A foreign key constraint can reference other tables only within the same database. This means that even if those databases were on the same server it still would not work.

Considering that the schemas are the same, you may want to look into replication.

Post a Comment for "How To Make Foreign Key Relationship On Physically Distributed Data?"