CREATE TABLE [dbo].[ObjectInfo](
[ObjectInfo] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WebSiteGroup] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DBName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ObjectName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_ObjectInfo] PRIMARY KEY CLUSTERED
(
[ObjectInfo] ASC,
[WebSiteGroup] ASC
)WITH
(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [UK_ObjectInfo] UNIQUE NONCLUSTERED
(
[ObjectName] ASC,
[DBName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
别人以前保存的脚本,我用他新建表的时候出错,那家伙现在辞职走人了
[ObjectInfo] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WebSiteGroup] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DBName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ObjectName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_ObjectInfo] PRIMARY KEY CLUSTERED
(
[ObjectInfo] ASC,
[WebSiteGroup] ASC
)WITH
(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [UK_ObjectInfo] UNIQUE NONCLUSTERED
(
[ObjectName] ASC,
[DBName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
别人以前保存的脚本,我用他新建表的时候出错,那家伙现在辞职走人了
Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
[ObjectInfo] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WebSiteGroup] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DBName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ObjectName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_ObjectInfo] PRIMARY KEY CLUSTERED
(
[ObjectInfo] ASC,
[WebSiteGroup] ASC
),
CONSTRAINT [UK_ObjectInfo] UNIQUE NONCLUSTERED
(
[ObjectName] ASC,
[DBName] ASC
)
) ON [PRIMARY]
[ObjectInfo] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WebSiteGroup] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DBName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ObjectName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_ObjectInfo] PRIMARY KEY CLUSTERED
(
[ObjectInfo] ASC,
[WebSiteGroup] ASC
) ON [PRIMARY],
CONSTRAINT [UK_ObjectInfo] UNIQUE NONCLUSTERED
(
[ObjectName] ASC,
[DBName] ASC
) ON [PRIMARY]
) ON [PRIMARY]改成这样可以了 不知道with一长串是干嘛的。。跟楼上答案一致。。