Re: Primary Key and and Index

From: <cmohan_at_iname.com>
Date: Mon, 13 Apr 1998 11:42:03 -0600
Message-ID: <6gtf8r$6nm$1@nnrp1.dejanews.com>

Primary key coulmn cannot have a null value, where as a unique index column can have a null value.

In article <6gt4ol$8up$1_at_as1000.javanet.com>, "George Meltser" <meltser_at_aigfpc.com> wrote:
>
> The main difference is that a primary key may be disabled and enabled, while
> an index must be dropped and recreated.
>
> Pete Cruz wrote in message <352d395a.325168_at_news.us.dell.com>...
> >I just wanted to know the difference between a Primary key and a
> >unique indexed column.
> >
> >Thanks
> >
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 13 1998 - 12:42:03 CDT