Forum Discussion
Foreign keys not visible in database explorer
Hi, it isn't possible to create a diagram to view the table relationships.
However the experience for both primary and foreign keys is to improve, certainly, also by implementing a graphic object to mark them, f.e. by a specific icon.
Thanks
Thank you for providing the additional details and your feedback. I agree that including a visual indicator for foreign keys, similar to the PK label for primary keys, would make it easier to identify relationships in the explorer.
Currently, this appears to be the expected behavior of the UI, not an issue with your configuration. Your suggestion to add an icon or marker for foreign keys is a valuable idea for improving the user experience.
Hi pmscorca ,
Thank you for confirming that the foreign key has been created. Even with an explicitly defined FK, it might not appear in the explorer in the same way as primary keys. This is due to how the explorer displays metadata primary keys are often more visible, while foreign keys may not be.
There isn’t dedicated documentation on this, but the FK should still exist and function properly in the database.
You can also check the constraints section or use a diagram/model view to see the relationships more clearly.
Hope this helps.
Hi, it isn't possible to create a diagram to view the table relationships.
However the experience for both primary and foreign keys is to improve, certainly, also by implementing a graphic object to mark them, f.e. by a specific icon.
Thanks
Thank you for providing the additional details and your feedback. I agree that including a visual indicator for foreign keys, similar to the PK label for primary keys, would make it easier to identify relationships in the explorer.
Currently, this appears to be the expected behavior of the UI, not an issue with your configuration. Your suggestion to add an icon or marker for foreign keys is a valuable idea for improving the user experience.