Re: Unique Key Constraint

The ones who think they know the most like to nitpik. Typically why I don't answer in open forums -- you get lots of folks who just can't leave well enough alone. Folks have to get their 2 cents in thinking they are the "DBA masters" ....

And there is such a thing as a unique key

VOMIT Ed Prochak wrote:
> Greg wrote:
> > 1. A table can only have 1 primary key (which is always unique)
> > 2. A table can have 1 or more unique index keys but still only 1
> > primary key.
> >
>
>
> just a minor terminology nitpik
>
> a table can have one Primary key
> a table can have one of more Foreign Keys
> a table can have one or more unique Constraints
>
> I don't think there is such a thing as a Unique key
>
> Ed
Received on Fri Jun 23 2006 - 13:08:11 CDT