How can I see table structure in HSQLDB?
I use following query in HSQLDB to see column information of a particular table:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS where table_name = '<TABLE_NAME>'
The information is provided by the views in the INFORMATION_SCHEMA
SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES
SELECT * FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS
In version 2.x, additional views are available containing more detailed information:
SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
You can select from single or joined views and filter the results on schema, table, column names and table type. The last you can use to show non-system tables only.
SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES where TABLE_TYPE='TABLE'