> Can anyone help with a couple of questions from a new Base user (I am just > using the 'out of the box' HSQL engine and embedded database).. > > > > 1) I am trying to find a HSQL query which will return the syntax used to > create tables. > > I am currently using a combination of wizard and design modes and would > like > to be able to get the statements used to create tables so I can produce > new > ones quickly. > > I know I can just copy table definitions but I want the syntax! > > I could also write the SQL myself but I think it must be held somewhere - > I > just don't know where / how to find it / how to retrieve it. > > > > 2) I would also like to get access to where metadata such as size, how > many > rows, when last modified etc is held on the tables I have created. > > Does anyone know where this data is held? Can I access it directly? Do I > need to create my own tables to record this info?
I have examples in AndrewBase.odt on my web site (http://www.pitonyak.org) using Macros. I do not think that I demonstrate directly SQL, however. Also, there might be good examples at the oooforum, have you checked there? Andrew Pitonyak --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
