Thanks! On May 12, 4:34 pm, Kerry Sainsbury <[email protected]> wrote: > 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%2bunsubscr...@googlegr > > oups.com> > > . > > 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 > athttp://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.
