Dan Lewis wrote:
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]
HSQL uses a schema INFORMATION_SCHEMA with the data.
select * from INFORMATION_SCHEMA.SYSTEM_TABLES
gives you the most basic view.
For details look at the HSQLdb documentation at hsqldb.org
Also, download and run the demo, the information_schema is available using
the demo swing manager. There is no way to display the tables in that schema
directly in the Base window, but you can run queries using the schema
name attached
as in the example above.
HTH
Drew Jensen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
