Take the 2-minute tour ×

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...

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

HSQLDB supports the INFORMATION_SCHEMA as well:


share|improve this answer
Hmm ok, I'm having an old version of HSQLDB then. :) –  GhiOm Jun 24 '11 at 9: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 9:20
add comment

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

share|improve this answer
add comment

Your Answer


