SQL error with script to create
Posted
by PapaDaniel
on Stack Overflow
See other posts from Stack Overflow
or by PapaDaniel
Published on 2009-04-15T20:40:58Z
Indexed on
2010/05/03
15:18 UTC
Read the original article
Hit count: 320
I used the SQL Server management studio on a table with Create Script to New and did minor changes. Give me an error "Incorrect syntax near '('" for the "(" after "WITH"
/* EventType Table Creation */
CREATE TABLE [EventType]
(
[pkEventID] [int] IDENTITY(1,1) NOT NULL,
[Description] [nvarchar](50) NOT NULL,
[BeginDate] [datetime] NOT NULL,
[EndDate] [datetime] NOT NULL,
[Comments] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_EventType] PRIMARY KEY
CLUSTERED
(
[pkEventID] ASC
)
WITH
(
PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
)
ON [PRIMARY]
)
ON [PRIMARY]
GO
© Stack Overflow or respective owner