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

Answer 2

This is the query that you need.

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '<your schema>' AND TABLE_NAME = '<name table or view>';