# Revision history [back]

Hello,

There are no requirements for constraint naming. If the key is set correctly it should appear. List your key(s) with the following SQL to insure they are actually present:

HSQLDB v1.8 (default embedded):

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLE_CONSTRAINTS


HSQLDB v2.x (split):

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS


Hello,

There are no requirements for constraint naming. If the key is set correctly it should appear. List your key(s) with the following SQL to insure they are actually present:

HSQLDB v1.8 (default embedded):

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLE_CONSTRAINTS


HSQLDB v2.x (split):

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS


Edit:

You have not specified the DB (or connector type if appropriate) you are referring to. While the above is true in most cases, there are some situations (SqLite comes to mind) where display may be a problem.