Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.