I don't think you more than one col at at time, but you could create a new table with all of the columns you want and then do an insert into or an append to move the data, drop the original table and rename the new one.
Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bernie Corrigan Sent: Tuesday, July 13, 2004 4:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Adding more than one column to table with a single command? Is it possible to add more than one column to a table with a single command a la: ALTER TABLE Ord_det ADD COLUMN `S_city` TEXT 20, + COLUMN `B01Date` DATE, + COLUMN `Binttest` INTEGER OR ALTER TABLE Ord_det ADD `S_city` TEXT 20, + `B01Date` DATE, + `Binttest` INTEGER or whatever the correct syntax is. I get an "Invalid column constraint" error no matter what syntax I use in an attempt to add multiple columns with just one command. Single ALTER commands for adding one column at a time function perfectly well. Suggestions? TIA, Bernie
