Add Primary Key Later

[MJV57]

I have a table that I want to add a primary key too.
I have added the field prikey but I have to insert consecutive numbers in the table fro prikey before setting it as the primary key. Can anyone help me with some simple code to populate the table with consecutive numbers for prikey

 

[jbenson001]

Make your prikey column an identity column, and use a seed of 1. You can use SSMS to do this with the GUI or in code.

 

[gmmastros]

Do you want an identity column? I mean, if you add a prikey column, I assume it's an integer. If you make it an identity column at the time you add it, you will get your consecutive numbers already.

For example:

Alter Table YourTableName Add prikey int identity(1,1)
Alter Table YourTableName Add Constraint PK_YourTableName Primary Key Clustered (PriKey)

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Do you want this for the existing table? Then one of the ways would be to create a new table with the same structure as existing + extra field (indentity (1,1)).

Insert into NewTable select * from OldTable

Drop table OldTable

and then rename the NewTable to OldTable.