Re: [Hsqldb-user] re trieve names of table fields/columns

[fredt <fr...@us...>]

With JDBC, you use the DatabaseMetaData interface to get the column names 
and info. See the JavaDoc supplied in the /doc folder of the jar.

You can also use SQL. For example:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS. See the Guide for a list of system 
tables.


----- Original Message ----- 
From: "zqzuk" <ziq...@ho...>
To: <hsq...@li...>
Sent: 24 June 2009 15:38
Subject: Re: [Hsqldb-user] re trieve names of table fields/columns



thanks but is there a way to achieve this with java jdbc api or hsql api?

thanks!




Christian Beil wrote:
>
> I usually use SchemaCrawler for this.
>
> http://schemacrawler.sourceforge.net/
>
>
>
> zqzuk schrieb:
>> Hi, I am new to HSQL and I am learning to use HSQL1.9 Beta. In my case I
>> know
>> the name of tables, and I need to use query to find out what
>> fields/column
>> names are defined in this table. What is the proper HSQL command I should
>> use?
>>
>> Many thanks in advance!
>>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Hsqldb-user mailing list
> Hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>

-- 
View this message in context: 
http://www.nabble.com/retrieve-names-of-table-fields-columns-tp24183045p24186077.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.


------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user