Hi all, Many thanks for all the suggestions. They have been a big help. I will post what I did / what worked for me asap but I will need a month or so to play around. Darren
> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> Subject: Re: [dba-dev] Re: > [users] finding database table definitions / metadata with HSQL??> Date: Wed, > 6 Jun 2007 08:13:23 -0500> > This one should be the one that helps you the > most.> > Dan> > On Wednesday June 06 2007 2:27 am, Frank Schönheit - Sun > Microsystems > Germany wrote:> > Hello Dan/Darren,> >> > >>1) I am trying to > find a HSQL query which will return the syntax> > >>used to create tables.> > >> > see the documentation of the SCRIPT command at hwwp://hsqldb.org.> > > SCRIPT allows you to write a script file which would generate your> > > database - including the commands to create the tables.> >> > Ciao> > Frank _________________________________________________________________ Try Live.com - your fast, personalised homepage with all the things you care about in one place. http://www.live.com/?mkt=en-gb