[MySQL] foreign key not visible

hello

foreign keys are no longer visible in the "foreign keys" tab of the table description, nor in the "Code CREATE" tab while a "SHOW CREATE TABLE" query displays them correctly

Could you please post the version of HeidiSQL and of the server you are using?

Also, the CREATE code for both t_foo and t_child_foo would be helpful to reproduce.

see attachments

Thanks for the details. Can confirm that!

Reason is that MySQL 5.0 did not have the REFERENTIAL_CONSTRAINTS view in information_schema. The query for the detection shows an error in the log panel:

SELECT * FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t_child_foo' ORDER BY ORDINAL_POSITION;
SHOW INDEXES FROM `t_child_foo` FROM `test`;
SELECT * FROM information_schema.REFERENTIAL_CONSTRAINTS WHERE   CONSTRAINT_SCHEMA='test'   AND TABLE_NAME='t_child_foo'   AND REFERENCED_TABLE_NAME IS NOT NULL;
/* SQL Error (1109): Unknown table 'referential_constraints' in information_schema */

That view was introduced later (in MySQL 5.1 I think).

I would anyway highly recommend updating MySQL here. MySQL 5.0 is from 2008.

but it worked with previous versions (see attachments) updating the version of MySQL is not an option at the moment

Yes, the code in HeidiSQL 10.x could detect these, but not those from newer MySQL versions. Also, the old approach was slower than the current.

Sorry but I don't support such old server versions.