Forum Discussion

pmscorca's avatar
pmscorca
Kudo Kingpin
4 months ago
Solved

Foreign keys not visible in database explorer

Hi, when I create a relationship between two tables I've noticed that the related foreign key isn't visible in the database explorer, while for the primary keys at least it is reported the "pk" acro...
General Question
SQL database
  • pmscorca's avatar
    pmscorca
    3 months ago

    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

  • V-yubandi-msft's avatar
    V-yubandi-msft
    3 months ago

    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.

     

     

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
3 months ago

Hi pmscorca ,

Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.