Re: Foreign superkey support

Marshall wrote:

>

 For example,
> we often speak of a foreign key constraint as belonging to
> one particular table, but it is equally a constraint on two tables.
> On one table it restricts inserts and on another table it restricts
> deletes. So we must necessarily classify it as a database
> constraint. But really, all constraints are all database constraints,
> although there may be some database constraints that only
> happen to be quantified over a single relvar.
>

I tend to visualize a foreign key as a pipe, it defines a meaningful transfer of data from one table to another.

-- 
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)