More on this: MySQL also supports multi-column ADD, as per this example:
ALTER TABLE customer ADD (foo INTEGER, foo2 INTEGER); I had a go at adding this feature to H2 as per Oracle's and MySQL's syntax, and I've had success. Now adding four columns at once takes about the same time of previously adding just one column. For my specific use case this is a great win. The use case is updating existing user databases that may be Gigaytes in size. A 30 minute update is far better than a 2 hour update. Regards, Steve On Feb 20, 8:25 pm, Steve McLeod <[email protected]> wrote: > Hi Thomas & co, > > Currently if I want to add 2 or more columns to a table in H2, I need > to execute multiple ALTER TABLE ADD commands: > > ALTER TABLE customer ADD foo INTEGER; > ALTER TABLE customer ADD foo2 INTEGER; > > Oracle allows adding two columns at once: > > ALTER TABLE customer ADD (foo INTEGER, foo2 INTEGER); > > So does Microsft SQL Server's T-SQL: > > ALTER TABLE customer ADD foo INTEGER, foo2 INTEGER; > > I'd like to have a go at adding this to H2. If I do, is this something > you'd be likely to add to the SVN trunk? If so, is the SQL Server > syntax or the Oracle syntax preferable? As far as I can tell, the > SQL-92 standard doesn't cover this scenario. > > Regards, > > Steve -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
