SQL Server Management Studio 2012 中的自动递增主键 [英] Auto increment primary key in SQL Server Management Studio 2012

问题描述

如何自动递增 SQL Server 数据库表中的主键?我浏览了论坛，但不知道如何执行此操作.

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 to do this.

我查看了属性，但看不到选项.我看到了一个答案，您转到 Identity 规范属性并将其设置为 yes 并将 Identity increment 设置为 1，但该部分是灰显，我无法将 no 更改为 yes.

I've looked at the properties but can't see an option. I saw 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.

一定有一个简单的方法可以做到这一点，但我找不到.

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

推荐答案

确保Key列的数据类型为int，然后手动设置identity，如图

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

或者只运行这段代码

-- 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)

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

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

图片参考fifo的

这篇关于SQL Server Management Studio 2012 中的自动递增主键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！