How to display sql-made foreign keys in relationships editor?

English
, ,
#1

When I create foreign keys by sql, they don’t show in the relationships editor window. What makes which constraints are graphically shown and which are not? Do I have to give my sql-made constraints a specific name (like FK_SYS_)?

#2

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.

#3

Connected to a MySQL (=MariaDB v 10.0.31 SLE12 sp2 ) over JDBC (MariaDB connector) : Relations, created with SQL, show up

#4

MySQL Native also show.

#5

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.