Multiple ADD COLUMN in one shot?

[JR]

I have a statement in a query like:

ALTER TABLE EXP ADD COLUMN first_name TEXT(75);

If I wanted to add 5 columns in one shot, how would I do this? Trying
to save this for repeatitive execution when I remove and recreate the
primary table from the DB. Putting even 2 alter table statements in a
row error. Guessing because this is a "Query", singular, and not a
script but wondering if this is possible.

Thanks.

JR

 

[Guest]

Try

ALTER TABLE EXP ADD COLUMN first_name TEXT(75), Last_name TEXT(75) , City_Id
Long, Phone Text (12);

etc

 

[Guest]

To get slightly better DDL facilities, use ADO or 'ANSI mode'
instead of DAO or 'Access SQL' mode.

Application.CurrentConnection.Execute("my DDL")

However, to remove and recreate table, I would save a template
table, then re-create with a make-table query.

(david)