Yasin Okumuş
Yasin Okumuş

Reputation: 2398

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?

Upvotes: 11

Views: 18757

Answers (3)

pacoverflow
pacoverflow

Reputation: 3891

user's answer works, but I find the following yields easier to read output in a terminal:

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME='tablename';

Upvotes: 0

user
user

Reputation: 987

I use following query in HSQLDB to see column information of a particular table:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS where table_name = '<TABLE_NAME>'

Upvotes: 3

fredt
fredt

Reputation: 24382

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' 

Upvotes: 25

Related Questions