Surya \’s Blog

… ever streaming tools and technologies….!!!

Posts Tagged ‘SQL Server’

Sql Server add auto increment primary key to existing table

Posted by kathayat on December 4, 2015

Create column and fill with identity values

ALTER TABLE dbo.YourTable
   ADD ID INT IDENTITY

then make it the primary key:

ALTER TABLE dbo.YourTable
   ADD CONSTRAINT PK_YourTable
   PRIMARY KEY(ID)
Advertisements

Posted in Database, Uncategorized | Tagged: , | 1 Comment »