cannot add new column (Incorrect syntax near the keyword 'COLUMN')

Question

When I run this

ALTER TABLE agency
ADD COLUMN single_word varchar(100)

I get

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'COLUMN'.

I tried removing the COLUMN but still same problem.

Answer 1

For TSQL Flavor try this syntax:

ALTER TABLE agents
ADD [associated department] varchar(100)

Answer 2

I have same issue when running that query on HeidiSQL. The solution is simple, change the query to be like this:

ALTER TABLE "agency"
ADD "single_word" varchar(100)

just remove "COLUMN" keyword.