Pete Freitag Pete Freitag

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.

If you like reading about sqlserver, or sql then you might also like:

Discuss / Follow me on Twitter ↯

Post a Comment