Re: Should I use PK or Unique Index in this table ?

Hi,
SO what should I use on the table ?
Can I define it as NULLable and put Unique index on it ?

Thank you,
Xtanto

Kenneth Koenraadt wrote in message news:<4159068a.423093_at_news.inet.tele.dk>...
> On 27 Sep 2004 22:16:51 -0700, krislioe_at_gmail.com (xtanto) wrote:
>
> >Hi gurus,
> >
> >I have a employee table, when an employee firstly input into the
> >system, he/she does not have Emp_Number yet, after some approval
> >process only then Emp_Number is generated.
> >
> >Question is : since Emp_Number can be null at first, should I have PK
> >on this table ? or just Unique Index ?
> >
> >Thank you,
> >xtanto
>
> Hi Xtanto,
>
> Primary Key = Unique + Not Null ===>> Primary key constraint on
> Emp_number not possible.
>
>
> - Kenneth Koenraadt
Received on Tue Sep 28 2004 - 06:11:47 CDT