Re: columns of a unique index
Date: Wed, 14 May 2008 16:03:26 -0400
It is allowed to have nullable columns in a unique index. However, in a Primary Key constraint all the columns has to be NOT NULL.
A unique key could more accurately be referred to as an Alternate Key.
On 5/14/08, Oxnard Montalvo <oxnard_at_carolina.rr.com> wrote:
> Think it is ok to have them nullable? why or why not. Seem like in general they act as another PK on a table.