How to alter an existing column in a table to become a primary key/identity column?

re: How to alter an existing column in a table to become a primary key/identity column?

WindowsDave — Tue, 18 Dec 2007 13:47:09 GMT

I think that I should give a try to this. But is it not that simple as it seems to be after reading this post.

re: How to alter an existing column in a table to become a primary key/identity column?

Mischa Kroon — Wed, 19 Dec 2007 12:37:24 GMT

whats wrong with:

ALTER TABLE tablename ADD CONSTRAINT

PK_tablename PRIMARY KEY CLUSTERED

(ID)

Way shorter, and more readible :)

re: How to alter an existing column in a table to become a primary key/identity column?

Walzenbach — Wed, 19 Dec 2007 12:56:24 GMT

Hi Mischa,

using ALTER TABLE the way you described would >>only<< set a primary clustered key on [ID]. All the mumbo-jumbo is necessary to generate the identity field.

Thanks

Daniel