How to create sub groupings of entities in ERD

I have just imported over 100 table definitions from existing system that has no documentation.
It’s impossible for someone to get a feel for something that large.

I’d like to create separate groupings.
E.g. Customer related tables (20+ of them). Product related tables (10+).
Order Mgmt (30+) etc etc.
If I could have each grouping in their own space where I could show relationships and print out it would be much more manageable.

I thought sub diagrams might be it but looks like not so.
This tool has so many features I feel like it might be there but I cannot find it.
Any thoughts? TIA

Hi DG1,

Thank you for your post. Would you consider grouping the entities by diagrams? You can create one ERD to visualize the customer-related tables, another for product-related tables, and so on.

To create an ERD:

  1. Select Diagram > New from the main menu
  2. Select Entity Relationship Diagram and click Next.
  3. Select Blank and click Next.
  4. Enter the diagram name and click OK.

Then, you can drag your entities from the Model Explorer onto the diagram:
image

To show the Model Explorer, select View > Panes > Model Explorer from the main menu.

Note: An entity can be visualized in more than one diagram.

Hope this helps. If you have any questions, please feel free to contact us again.

Best regards,
Jick Yeung

That worked. Thanks! Appreciate the visual too.
Found an even better way which is to do Search for table names only and move them.
The fact that I can do multiple searches and each result set keeps adding to results is super helpful.
I did searches for all the various similar tables and move them to diagram in one go. Great.

You are welcome! :slight_smile: