[RESOLVED] Adding A Field To A Table

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" :D )

Isn't it just:

ALTER TABLE XYZ ADD NEWCOLNAME INT

I think the COLUMN is assumed...

Quote:

---

Originally Posted by szlamany

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. :rolleyes:

Thank you sir!