如何在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?

如何在HSQLDB中查看表的结构（列的详细信息等）？它不像Oracle那样“desc”，那又怎样？

1 个解决方案

#1

The information is provided by the views in the INFORMATION_SCHEMA

信息由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:

在2.x版中，可以使用包含更多详细信息的其他视图：

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'

#1