sql-server - SQL Server Management Studio 2012中的自动递增主键(Auto increment primary key in SQL Server Management Studio 2012)

Question

How do I auto increment the primary key in a SQL Server database table, I've had a look through the forum but can't see how.

(我如何在SQL Server数据库表中auto increment primary key ，我已经浏览了论坛，但看不到如何。)

I've looked the the properties but can't see an option, I have seen an answer where you go to the Identity specification property and set it to yes and set the Identity increment to 1, but that section is grayed out and I can't change the no to yes.

(我看过属性，但看不到选项，我看到了一个答案，您可以转到Identity规范属性，并将其设置为是，并将Identity increment设置为1，但是该部分显示为灰色，我可以不要将“否”更改为“是”。)

There must be a simple way to do this but I can't find it.

(必须有一种简单的方法来执行此操作，但我找不到它。)

  ask by Ledgemonkey translate from so

Answer 1

Make sure that the Key column's datatype is int and then setting identity manually, as image shows

(确保Key列的数据类型为int ，然后手动设置身份，如图所示)

Or just run this code

(或者只是运行此代码)

-- ID is the name of the  [to be] identity column
ALTER TABLE [yourTable] DROP COLUMN ID 
ALTER TABLE [yourTable] ADD ID INT IDENTITY(1,1)

the code will run, if ID is not the only column in the table

(如果ID不是表中的唯一列，则代码将运行)

image reference fifo's

(图像参考fifo)