I have 2 database, one with all static config data and another one is the us
er data. There is a table in the user database one column have to refer the
column in static database, can I add a foreign key to it that refers a prima
ry key in static database?
how? ThanksYou can use a trigger to emulate a FK between tables in different databases
or servers even.
"Jen" <anonymous@.discussions.microsoft.com> wrote in message
news:92C2B56D-747A-4960-8C84-AA8B6C106E27@.microsoft.com...
quote:
> Hi,
> I have 2 database, one with all static config data and another one is the
user data. There is a table in the user database one column have to refer
the column in static database, can I add a foreign key to it that refers a
primary key in static database? how? Thanks
No comments:
Post a Comment