sql-server - 'Employees' 不包含身份列

Question

我正在尝试为我的表列重新设定种子但出现错误

'Employees' does not contain an identity column

我检查了我的表，它确实有一个 ID 列。

DDL

CREATE TABLE [dbo].[Employees]
(
    [ID] [int] NOT NULL, 
    [FirstName] [nvarchar](max) NULL, 
    [MiddleName] [nvarchar](max) NULL, 
    [LastName] [nvarchar](max) NULL, 
    [Email] [nvarchar](max) NULL, 

    CONSTRAINT [PK_Employees] 
        PRIMARY KEY CLUSTERED ([ID] ASC)
)

Answer 1

您需要将列指定为 IDENTITY列，它不是假定的/隐含的。

CREATE TABLE [dbo].[Employees]
  ([ID] [int] IDENTITY(1,1) NOT NULL, 
  -- rest of columns