如何在 SQL Server 中将标识列设置为创建的表

2022-01-16 00:00:00 sql-server sql-server-2008-r2

我在 SQL Server 中这样创建了一个表:

I created a table in SQL Server like this:

CREATE TABLE [UserName]
(
   [ID] [int] NOT NULL ,
   [Name] [nvarchar] (50) NOT NULL ,
   [Address] [nvarchar] (200) NULL

   CONSTRAINT [PK_UserName] PRIMARY KEY CLUSTERED ([ID] ASC)
) ON [PRIMARY]
GO

如果我想让 ID 成为一个标识列，我需要什么?我是否需要删除并创建此表并将 ID 设置为 [ID] [int] IDENTITY(1,1) NOT NULL .

If I want to make ID an identity column, what do I need? Do I need to drop and create this table and set ID to [ID] [int] IDENTITY(1,1) NOT NULL .

使用 drop 和 create，UserName 表中的所有数据都会丢失.

By using drop and create, all of data from UserName table are lost .

还有其他方法可以将 IDENTITY COLUMN 设置为 created table 的列而不丢失数据吗?

Is there another way to set IDENTITY COLUMN to created table's column without losing data?

我使用 SQL Server 2008 R2 :)

I use SQL Server 2008 R2 :)

推荐答案

ALTER TABLE [UserName] DROP COLUMN [ID];

ALTER TABLE [UserName] 
    ADD [ID] integer identity not null;

相关文章