1. Jorge Adamicska
  2. Valentina Studio
  3. Saturday, May 27 2023, 01:03 AM
  4.  Subscribe via email
Hello,
In the schema editor of Valentina Studio Pro, I have noticed that foreign keys appear under the Links subcategory under the tree view. When I go to edit a table, under the constraints tab I see a foreign keys tab but no entries appear there, not even the ones associated with fields in the edited table. I can understand from the development point of view the need to have a different interface to create the links (foreign keys) but they should at least be listed under the appropriate table. The tree view of the links is extremely generic and very hard to see if all the necessary foreign keys for a certain table have been created.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Jorge,

In the Tree View, select the Links list of the table.
You can see a table view with all of the foreign keys involving this table along with their properties - schemas, and tables.
In the context menu of the header of this table view select Choose Shown Properties and check Primary Key and Foreign Key properties.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Jorge Adamicska Accepted Answer
Thank you for the quick response. I was hoping to see this info when designing the table but this will do.as well
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories