Re: quick FK question

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: JSweetser@xxxxxxxx
  • Date: Tue, 15 Dec 2009 22:29:39 +0100


   You have answered your own question. The FK says 'any value here must
be found in the referenced table'. But as Chris Date would tell you,
even if many people speak (wrongly) of "null values", NULL is not a
value - it's the absence of a value. Nothing violates no constraints.



Sweetser, Joe wrote:
> I'm having trouble understanding FK's and NULL's.  It appears I can
> insert a null value to a foreign key which is not what I would expect.
> Is the "solution" to put NOT NULL on the column definition?
> Thanks,
> -joe


Other related posts: