Hi, I would probably use a combination of table renaming and create table ... as select.
Regards, Thomas On Thursday, September 17, 2015, Rinse Lemstra <r.lems...@xso.nl <javascript:_e(%7B%7D,'cvml','r.lems...@xso.nl');>> wrote: > Hello, > > Is it correct that ALTER TABLE DROP COLUMN does not support multiple > columns in one statement ? > > As I have to drop more then one column in a rather large table it would be > very efficient to do this in one statement. > > regards, > > Rinse > > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
