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 h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.