SHOW COLUMNS Command for HSQLDB

Question

Is there an HSQLDB equivalent for the MYSQL SHOW COLUMNS from TABLE command?

Answer 1

HSQLDB does not have separate commands for showing tables, columns or other database objects.

You use SELECT * FROM INFORMATION_SCHEMA.COLUMNS and various other tables in the INFORMATION_SCHEMA for such purposes.

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