Re: Help: What is the difference between UNIQUE and PRIMARY KEY?

Hi,

A unique field requires that each entry be different (unique) from every other record OR NULL.

A primary key imposes a second condition, namely the NOT NULL condition...so, the field must be both unique and not null.

Hope this helps,
Steve

u518615722_at_spawnkill.ip-mobilphone.net wrote:

> I searched against metalink and could not find the
> definition of unique index, could somebody help
> me out?
>
> Thanks
>
>
> --
> Sent by dbadba62 from hotmail subpart of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Apr 12 2001 - 06:34:52 CDT