This should do it for you: create table NewTable as SELECT * FROM ExistingTable LIMIT 0
http://www.h2database.com/html/grammar.html#create_table Cheers Kerry On Thu, May 13, 2010 at 1:17 AM, Djam <[email protected]> wrote: > I want to create a new table with one of the existing table's > structure. > > In MS SQL I'd do it by "SELECT INTO NewTable SELECT TOP 0 FROM > ExistingTable". > > Is there any workaround for the same behavior in h2? > > Thanks, > D > > -- > 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]<h2-database%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- 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.
