CODEWITHSUNDEEP
sqlsql-serveralter-table
Si8
Si8

Reputation: 9225

Why receiving a SYNTAX error while ALTERing a SQL table

I have an existing SQL table and I am trying to add two more columns like this:

ALTER TABLE DSPCONTENT01.dbo.RADRESULTSTOTALS2
ADD ([TEST1] INT,
       [TEST2] INT);

I get the following error:

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '('.

How do I resolve it?

Upvotes: 2

Views: 69

Answers (1)

Crono
Crono

Reputation: 10478

Don't use parentheses.

ALTER TABLE DSPCONTENT01.dbo.RADRESULTSTOTALS2
ADD
    [TEST1] INT,
    [TEST2] INT

Upvotes: 3

Related Questions