ALTER TABLE Syntax

• lee.vance

  SSC Veteran

  Points: 291

  More actions

  July 24, 2008 at 7:05 am

  #71761

  We created our database in SQL 2005, but we are having to migrate it back to 2000 temporarily. The script that creates the table works fine in both versions, but the script creating our primary key only works in 2005. It appears that it doesn't like the WITH clause:

  ALTER TABLE dbo.FQCurriculum ADD CONSTRAINT

  PK_FQCurriculum PRIMARY KEY CLUSTERED

  (

  FQCurriculumID

  ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

  The error we get is:

  Msg 170, Level 15, State 1:

  Line 5: Incorrect syntax near '('.

  What do we need to do differently for it to work in 2000?

  Thanks,

  Lee

• Loner

  SSC-Insane

  Points: 21279

  More actions

  July 24, 2008 at 8:00 am

  #847774

  Just try to do this in SQL Server 2000

  ALTER TABLE dbo.FQCurriculum ADD CONSTRAINT

  PK_FQCurriculum PRIMARY KEY CLUSTERED

  (

  FQCurriculumID

  )