Table groups

[loicknuchel]

Often some tables work in close relation with some others. In fact, it's quite common to have a feature or a business domain which use several tables.
It could be useful to group such tables in a cluster and represent them visually.

MySQL Workbench has a similar feature:

Such clusters could also hide tables inside and have their relations linked to it directly (hide useless details for a clearer understanding).

Other inspirations:

• https://twitter.com/dbdiagram/status/1255356100402176000
• https://twitter.com/dbdiagram/status/1133213114458038275

If you think this feature can be useful for you, please react with a 👍 to let us know.

[aneudyac]

Azimutt will support SQL Server? I mean create a diagram directly from SQL Server engine.

If this happen, in SQL Server we use schema for grouping objects.

[loicknuchel]

Do you mean connecting to the database and extract the schema?

Yes, it's the next feature ^^ #92
(probably for september or october as it's a big one).

Still you can already import your database schema with multiple schema inside, or even import multiple schema in multiple sources. What you will miss, and it's the goal of this issue is to visually group tables like in the screenshot.
But will come at some point ;)

[aneudyac]

Yes, i mean connecting to the database and extract the schema!

I get some errors trying import SQL Server auto generate script from a large database, i think because the script contains a bunch of SQL Server particular stuff.

I will try with a more clear script.

[loicknuchel]

Ok. I'm trying to get a flexible SQL parser to handle all the dialects as much as possible (but of course, still have a lot of wholes ^^).
If you can send me the errors I can fix it so it will work for you without changing anything (and for other people also ^^).

[loicknuchel]

Mostly done with #212

Few features could still be added:

• drag group
• collapse group
• add group description, shown in a tooltip