I'm trying to add a new field to an existing table using this:
Code:
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" )