sql-server - SQL Server 2008 FactFinance 主键

Question

我有这个脚本的问题

SET ANSI_NULLS ON
GO 

IF NOT EXISTS (SELECT * FROM [sys].[tables] 
               WHERE [object_id] = OBJECT_ID(N'[dbo].[FactFinance]') 
                 AND OBJECTPROPERTY([object_id], N'IsUserTable') = 1)
BEGIN
    CREATE TABLE [dbo].[FactFinance]
    (
        [FinanceKey] [int] IDENTITY PRIMARY KEY NOT NULL,
        [TimeKey] [int] NULL,
        [OrganizationKey] [int] NULL,
        [DepartmentGroupKey] [int] NULL,
        [ScenarioKey] [int] NULL,
        [AccountKey] [int] NULL,
        [Amount] [float] NULL
    ) ON [PRIMARY];  
END
GO

SET ANSI_NULLS OFF
GO

当我运行它时，我得到了这个结果：

但是如果我[Finance Key] [int] IDENTITY PRIMARY KEY NOT NULL从脚本中删除这一行，它就可以工作

标签： sql-serversql-server-2008ssis-2008