On Friday June 01 2007 9:56 am, Darren Norris wrote:
> 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?
>
> Many thanks to anyone who can point me in the right direction..
This is a question best answered by another mailing list:
[EMAIL PROTECTED] I have sent a copy of this email to that list
as well.
This person will need to be CC'd if anyone has answers to his
questions.
I will say that all the information for the database is kept in
the database file. This is a zip file, so you can unzip it and look
at its contents.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
