Subject Re: [IBO] SQL question
Author G. Allen Casteran
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?

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