Creating PK via code

[John]

Hi

Is there a way to cerate PK via code in an existing table?

Thanks

Regards

 

[Tony Toews [MVP]]

Is there a way to cerate PK via code in an existing table?

You've got a good answer but what is your over all objective?

Tony

 

[John]

Just run through all tables in db and cerate PK where a table does not have
it. This is part of a long process which first requires a PK in each table.

Thanks

Regards

 

[Tony Toews [MVP]]

Just run through all tables in db and cerate PK where a table does not have
it. This is part of a long process which first requires a PK in each table.

Ok, makes some sense. A bit surprising there isn't already a PK but
stuff happens.

Tony