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

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