Search code examples
hsqldb

How can I see table structure in HSQLDB?

How can I see the structure (details of the columns etc) of a table in HSQLDB? It is not "desc" like Oracle, so what?

Solution

  • 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'