On 26.Jun.2003 -- 10:12 AM, Bruno PIERRE wrote:
> Thanks,
>
> It was already in my favorites, but it is not clear.
> i don't know how to list all the table, all the column of a table with their
> type (in SQL).
Most DBMS have special tables for the meta data. I don't know how
hsqldb does it. Anyway, I would suggest to go the jdbc route and use
the metadata api to query the dbms. Have a look at
java.sql.Connection#getMetaData() and friends for a start.
In addition, you could try to leverage
org.hsqldb.util.DatabaseManager. It contains code to read all the meta
data from the database. I've not looked at the exact code but I
believe it will provide good insight into using the meta data api of
jdbc and which parts are supported by hsqldb.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
