SQL Server Alter Table Query (Incorrect Syntax)

Question

I'm stumped, and I know this is probably something very simple. I am trying to add two columns to an existing table.

I am receiving the following syntax error:

Incorrect syntax near 'PublishedDate' Expecting '(', or SELECT.

Here is my SQL:

ALTER TABLE my_table ADD (PublishedDate DATETIME, UnpublishedDate DATETIME)

Lamak · Accepted Answer · 2013-05-06 16:10:31Z

6

Try without the parentheses:

ALTER TABLE my_table 
ADD PublishedDate DATETIME, UnpublishedDate DATETIME

Here is a sqlfiddle with a demo for you to try.

answered May 6, 2013 at 16:10

Lamak

70.8k12 gold badges119 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Wow, thank you! I knew it was going to be something right in front of my face