Alter Table Add Column on SQL Server
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
ALTER TABLE ADD column_name int
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:
- Order by NULL Values in MySQL, Postgresql and SQL Server
- SQL Case Statement
- Getting ColdFusion SQL Statements from SQL Server Trace
- Try Catch for SQLServer T-SQL