HSQLDB list all constraints

Question

Does anyone know how to list all constraints, or query for a particular Foreign Key constraint e.g. FK1234567890 in HSQLDB?

In other databases there are special system tables for this, but I can't find anything on the docs for this one.

Thanks, N.

Answer 1

HSQLDB system tables are listed in the Guide

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

The INFORMATION_SCHEMA.TABLE_CONSTRAINTS view has the overall information. Other tables list the columns used in constraints.

Answer 2

Here is a clear text version of above explanation, that really works for my:

       SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLE_CONSTRAINTS