检查Hsqldb模式 [英] Inspect Hsqldb Schema

问题描述

是否可以在Hsqldb独立模式下检查并随后修改现有模式?我尝试使用内置的管理工具查看文件，并连接SQuirrel SQL Client.

Is it possible to inspect and subsequently modify an existing schema in Hsqldb standalone mode? I've tried looking at the file using the built in admin tool as well as hooking up SQuirrel SQL Client.

我对各种表上存在哪些主键特别感兴趣.是否有与MySql的"show create table ..."或"describe"等效的命令?

I'm particularly interested in what primary keys exist on various tables. Is there command equivalent to MySql's 'show create table...' or 'describe '?

推荐答案

sqltool \ d 命令近似为描述"，并且主键信息存储在INFORMATION_SCHEMA下:

The sqltool \d command approximates a "describe", and primary key information is stored under the INFORMATION_SCHEMA:

sql> CREATE SCHEMA STACKOVERFLOW;
sql> SET SCHEMA STACKOVERFLOW;
sql> CREATE TABLE SO2406470 (pk1 INT NOT NULL, pk2 INT NOT NULL, data VARCHAR(64), PRIMARY KEY(pk1, pk2));
sql> \d SO2406470
name  datatype  width  no-nulls
----  --------  -----  --------
PK1   INTEGER      11  *
PK2   INTEGER      11  *
DATA  VARCHAR      64  
sql> SELECT * FROM INFORMATION_SCHEMA.SYSTEM_PRIMARYKEYS WHERE TABLE_SCHEM = CURRENT_SCHEMA AND TABLE_NAME = 'SO2406470';
TABLE_CAT  TABLE_SCHEM    TABLE_NAME  COLUMN_NAME  KEY_SEQ  PK_NAME
---------  -------------  ----------  -----------  -------  ------------
PUBLIC     STACKOVERFLOW  SO2406470   PK1                1  SYS_PK_10040
PUBLIC     STACKOVERFLOW  SO2406470   PK2                2  SYS_PK_10040

Fetched 2 rows

(hsqldb-2.0.0rc9)

(hsqldb-2.0.0rc9)

这篇关于检查Hsqldb模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！