Surf 11 » Alter Table Add Column on SQL Server

Finding the best waves on the web.

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



Related Entries
Name:

Email: (optional, not displayed on site)
   Subscribe to this thread
Comments: (html will be escaped)



Subscribe to our RSS Feed: subscribe to this feed XML
Archives   Tags   Contact