J
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
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