At 09:21 AM 1/11/2002 -0800, you wrote:

>Hi all,
>
>I need to add a primary key to a table, the field that I wish to have as PK
>is not define as NOT NULL.
>
>How can I define a primary key and define this field as not null without
>losing data?
>
>Thanks
>Daniel

3 Step process.
1) Add the field but declare as allowing NULL
2) Fill in the field for existign rows.
3) Change the field definition to NOT NULL and Primary Key

Allen.