Adding columns

[foreveryoung]

I want to add a column to a table and make that the primary key. I am using the following

alter table KH06AdmissionsTBL add column rowid int primary key

what am i doing wrong it said no nulls allowed but if i replace int to autonumber it still wont work.

Any DDL experts out there?

Many thanks
David

 

[eavan]

generally when trying to add a primary key to a DB after they have already been constructed means that you have to remove the relationships made.Watch out though,this might cause some problems so that is just my opinion.Cheers

 

[markgrizzle]

If rows already exist in the table, you can't make the new column the primary key since nulls aren't allowed, and the new column will have some.