Re: Primary Key and and Index

From: Saad Ahmad <saad.ahmad_at_mchugh.com>
Date: 9 Apr 1998 23:30:10 GMT
Message-ID: <01bd640f$6ae7b8e0$2207030a@sahmad-pc.mfa.com>

PK	only 1 per table
UK	more than 1 possible

PK	cant have null values in columns of PK
UK	can have null values

PK	*Suggsted* that every table should have it
UK	A table may or may not have it

When creating FK constraints, if just mention the table name for referenced table, PK columns are assumed

Pete Cruz <petec_at_eden.com> wrote in article <352d395a.325168_at_news.us.dell.com>...
> I just wanted to know the difference between a Primary key and a
> unique indexed column.
>
> Thanks
>
>
Received on Thu Apr 09 1998 - 18:30:10 CDT