Re: Foreign Key Question

From: <pbolduc_at_my-deja.com>
Date: Mon, 29 Nov 1999 05:18:06 GMT
Message-ID: <81t2ac$s60$1@nnrp1.deja.com>

If you make your FK column nullable then it is optional. Only when it is non-null will the FK be enforced.

Phil Bolduc
North Vancouver, BC Canada

In article <81rpln$4kc_at_freenet-news.carleton.ca>, bh243_at_FreeNet.Carleton.CA (Jeremy Gershberg) wrote:
>
> How would I go about ensuring that a relationship between two tables
is
> optional as opposed to mandatory.
>
> Currently I have 2 tables both with primary keys and one with a
foreign
> key referencing the other table.
>
> Jeremy
> --
> Jeremy Gershberg
> Nepean, Ontario, Canada
> Homepage & Grateful Dead/Related Artists CD-R List @
> http://www.geocities.com/sunsetstrip/amphitheatre/7076
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Nov 28 1999 - 23:18:06 CST