HSQLDB : Test presence of a column in a table

Question

Is there a way to send an SQL query to HSQLDB (edit : prior to version 2) to know the columns of a certain table ? (Similar to the inspection of the schemas through INFORMATION_SCHEMA in MySQL.)

Right now it seems to me I'm stuck with trying to SELECT column_name FROM table_name and see if I get an SQL error...

score 2 · Accepted Answer · edited May 22 '12 at 07:31

2

HSQLDB supports the INFORMATION_SCHEMA as well:

http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_information_schema

edited May 22 '12 at 07:31

fredt

24,044
3
40
61

answered Jun 24 '11 at 08:53

Hmm ok, I'm having an old version of HSQLDB then. :) – glmxndr Jun 24 '11 at 09:03
Versions of HSQLDB since 1.8 support INFORMATION_SCHEMA. The table you should query is INFORMATION_SCHEMA.SYSTEM_COLUMNS. Even older versions support the same table but no schemas. – fredt Jun 24 '11 at 09:20

score 1 · Answer 2 · edited May 23 '17 at 11:55

1

You use queries to the special SYSTEM tables. See the answers to [this question].1

edited May 23 '17 at 11:55

Community

1
1

answered Jun 24 '11 at 08:54

Kilian Foth

13,904
5
39
57

HSQLDB : Test presence of a column in a table

2 Answers2