我在执行SQL脚本时,系统报错:'OPTIMIZE_FOR_SEQUENTIAL_KEY' 不是可以识别的 CREATE TABLE 选项。我执行的SQL脚本如下:
CREATE TABLE [dbo].[WenZhang]( [ID] [int] IDENTITY(1,1) NOT NULL, [CourtID] [int] NOT NULL, [Title] [nvarchar](100) NULL, [AuthorID] [int] NOT NULL CONSTRAINT [PK_CourtArticle] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
查看本地sqlServer版本:
测试发现:
2016版本不支持,
2018 2019版本sqlserver中支持