Hi I'm VERY new to SQL and am having trouble with its syntax.
Brief: I need to add columns to my table that will be named TITLE, DESCRIPTION KEYWORDS ...that simple!

Here's my code:

ALTER TABLE Products ADD COLUMN description TITLE


Here's the error message:

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


AS always Your help is greatly appreciated,
Thanks

nancy

If its the basic syntax you're stuck with you could just look it up in Books On Line.

w3schools always have good basic tutorials:
http://www.w3schools.com/sql/

Your statement doesn't need the COLUMN keyword to add a column (but you do need it to drop a column!), and you also need to specify the data type of the new field. Plus you need one ALTER statement for each new column.

Sorry I'm wrong, you don't need one ALTER statement per column, you can separate multiple columns by a ,

You can also add the column(s) through enterpise manager.

To all,Thank you very much.
It was indeed a syntax error that is now resolved.

Nancy