[RESOLVED] Adding A Field To A Table

[SeanK]

I'm trying to add a new field to an existing table using this:

alter table users add column Staff_LVL int

and Query Analyser is saying: Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'column'.

Where is the syntax incorrect (and please don't say "near the keyword column" )

[szlamany]

Isn't it just:

ALTER TABLE XYZ ADD NEWCOLNAME INT

I think the COLUMN is assumed...

[SeanK]

Isn't it just:

ALTER TABLE XYZ ADD NEWCOLNAME INT

I think the COLUMN is assumed...

I was making things to hard on myself szlamany. You are correct...column is assumed.

Thank you sir!