Alter Table Add Column on SQL Server

Updated on November 17, 2023
By Pete Freitag

If you try running this command to add a new column on Microsoft SQLServer:

ALTER TABLE ADD COLUMN column_name int

You will get an error message:

Incorrect syntax near the keyword 'COLUMN'.

That's because SQL Server Doesn't like ADD COLUMN it prefers you just say ADD instead:

ALTER TABLE ADD column_name int

sqlserver sql

Alter Table Add Column on SQL Server was first published on March 24, 2009.