Re: Primary Key/Unique Key?

From: W. Scott Moore <sirws_at_hotmail.com>
Date: Tue, 7 Dec 1999 15:07:10 -0700
Message-ID: <ptf34.2027$je2.40854@news.uswest.net>

What if you want to have a field with all unique values including one null record, that doesn't allow for entering of multiple nulls. How would I setup the constraints for that? or is it possible.

Scott

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:384D0C88.328_at_yahoo.com...
> Dave wrote:
> >
> > Whats the difference between making something
> > a primary key and making something a unique key.
> > From Oracles point of view that is.
> > Dave
>
> Unique means that IF you give a value, then it must be unique.
> Primary means you MUST give a value always, and it must be unique.
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Tue Dec 07 1999 - 16:07:10 CST