HSQLDB lists all restrictions

Question

Does anyone know how to list all constraints or request a specific foreign key constraint, for example. FK1234567890 in HSQLDB?

In other databases there are special system tables for this, but I can not find anything in the documents for this.

Thanks N.

+5

Nikolaos Apr 2 '11 at 11:51

3 answers

, :

       SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLE_CONSTRAINTS

+7

primehunter 22 . '13 12:18

You can find contraint FK1234567890using this SQL:

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS 
    WHERE CONSTRAINT_NAME = 'FK1234567890'

To see the columns associated with the constraint:

SELECT * FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE 
    WHERE CONSTRAINT_NAME like 'FK1234567890'

+1

Dherik Sep 09 '16 at 20:19

fredt · Accepted Answer · 2011-04-02T12:14:07+0000

HSQLDB system tables are listed in the manual.

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