When you make a change in your SqlDBM database project, especially a structural or relationship change, you understand that of course, something is going to be affected, perhaps broken by this change. These alterations may be easy to keep track of and manage in small, simple projects. But keeping track of all updates, deletes and edits is far more unwieldy in a large, multi-team project with large numbers of tables and relationships, especially after reverse engineering. So recognizing this, we have introduced a new feature – Related Tables!
Related Tables – Details
How to access and view related tables? There are 2 ways to do this:
Use the new tab in Table Properties to highlight all related tables. Click on a table in your SqlDBM Diagram, and both it and its related tables will be highlighted. Plus, the Table Properties section on the far-right side will contain a subsection called Related Tables. In this subsection will be listed the same highlighted tables as in your diagram.
The 2nd way to do it is by using the context menu in the Database Explorer panel. Similar to the Diagram view, you can click on any table in the list in Database Explorer, and its related tables will be listed in the Related Tables subsection in Table Properties.
How to use it? If you make some changes in a table, then create a new diagram, drag the table to the Database Explorer panel and place it using the context menu. Then show related objects and analyze what you need to fix in them. All new changes, for example, new columns or other data, will appear in your common diagram.
Adding Related Tables
We understand that creating a database model is an intensive, creative process and that interruption to your ‘flow’ should be minimized. That is why the new Related Tables feature is deliberately custom-designed for the user to make the fewest number of actions. Select a table by clicking on it, you will see buttons to its left and right. The left button creates a parent table and right button creates a child table. As simple as that.
We hope you love this new feature. We would also really like to hear your comments, opinions and suggestions about it in our Support forum.