Re: foreign key w/o foreign/primary key

From: Ion Manea <imanea_at_ese.washington.edu>
Date: Mon, 15 Jan 2001 21:52:07 -0800
Message-ID: <3A63E187.FCDD9035@ese.washington.edu>

> Does anyone have an opinion on the most efficient way to check
> referential integrity on a table where the would-be foreign key is
> neither unique or primary? Would I use a check constraint? If so, how
> without a subquery?

How about making your schema relational?

Trying to cover a bad design up with code is a recipe for ... well you know.

Lots of things will work. But a redesign of something that is obviously flawed is the best answer.

Daniel A. Morgan Received on Mon Jan 15 2001 - 23:52:07 CST