Alter Table woes

[garbsmj]

On the ever-so-cludgy MS developer site, it says you can do the following:

ALTER TABLE (Mickey)
ADD Minnie_Text Varchar(20) Null;

Works fine, but I'd like to add multiple fields and supposedly you can do:

ALTER TABLE (Mickey)
ADD ( Minnie_Text Varchar(20) Null,
Pluto_Text Varchar(20) Null);

However, the second one doesn't work. It either errors out at the first parens or it doesn't like the comma. Now I don't mind copy/pasting and running through the table multiple times because, well, it is a one-time event. I'm just wondering what could be wrong with the second statement.

[Jezza]

Peggy

I used this syntax in Access2K3 and it worked fine

Code: Select all

ALTER TABLE Mickey
ADD  
Minnie_Text Varchar(20) Null,
Pluto_Text Varchar(20) Null;

[HansV]

Try it without the parentheses:

ALTER TABLE Mickey
ADD Minnie_Text Varchar(20) Null,
Pluto_Text Varchar(20) Null;

Oops - I was held up while replying. Jezza came up with the same SQL.

[garbsmj]

Oh...Okay. So my handy dandy sql book is wrong too.

Thanks Jerry and Hans! I don't know what I'd do without you guys. Well, probably a lot but you know....

[Jezza]

Oh...Okay. So my handy dandy sql book is wrong too.

Thanks Jerry and Hans! I don't know what I'd do without you guys. Well, probably a lot but you know....

I have a feeling the author was probablya mySQL developer at some stage as the sintax is very similar