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_)?
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.
Connected to a MySQL (=MariaDB v 10.0.31 SLE12 sp2 ) over JDBC (MariaDB connector) : Relations, created with SQL
, show up
MySQL Native also show.