[thelist] SQL - Foreign Key Constraint - in another database?

Joshua Olson joshua at alphashop.net
Fri Aug 31 16:05:05 CDT 2001


Merging the databases like you've suggested is most likely the only way to
be able to do queries that reference both sets of data.

-joshua

----- Original Message -----
From: "spinhead" <evolt at spinhead.com>
Subject: Re: [thelist] SQL - Foreign Key Constraint - in another database?


: Apologies; babbling incompletely again:
:
: MS SQL 2000 - created a db for our Request for PO application. It included
: employee info. Later, built a 'grand scheme' core db for other ongoing
: purposes, which also included employee info. PO app needs to reference the
: employee table in the new db now, but foreign keys from two tables point
to
: the original employee table.
:
: I'm thinking my only solution is to remove said constraints, move the
tables
: to the new db, then create new constraints.
:
: Is there an easier way?
:
: spinhead





More information about the thelist mailing list