A diagram helps visualize your database landscape, the objects it contains, and their relationships, but is not a database object itself.

Zoom and Fit

When you visualize a diagram, you can zoom in and out to display the desired amount of detail.

There are many ways to control the zoom level:

Mouse Scroll Wheel - rotate the scroll wheel to zoom in and out
Top Menu - Use the "Reset Zoom" or "Zoom to Fit" buttons
Diagram +/- Buttons - click the +/- buttons on the top left of the diagram
Diagram Context Menu - right-click on an empty space in the canvas and select the "Zoom to Fit" option

Diagram properties

There are many types of analysis that you can perform using diagrams and so, SqlDBM offers various properties and settings that can be customized to fit your needs.

There are three ways to call diagram properties:

Click on the Diagram name in the Diagram panel
Click on free space on the canvas
Click on the diagram tab on the top of the canvas

Diagram properties available:

Diagram - choose a subject area and set a name for the diagram
View mode options (e.g. schema name in table names, datatype, keys, color data type, fixed object height). These options apply to the current diagram only
Global User Preferences - These are "Disable zoom on scroll " and displaying of comments. These settings affect all diagrams in the project.
Notation - You can set IDEF1X or Crow's foot notation for relationships. This affects all diagrams in the project.
Description - provide a functional description of the diagram
Object Filter - Filter diagram objects by various attributes like color, flag, and group.

Object filter

Diagrams can be filtered by various attributes like color, flag, and group (and Tag for Snowflake projects).

When applying filters across multiple attributes (e.g., flag and color) choose between inclusion logic of AND (default) and OR.

Fixed object height

Sometimes user tables may contain dozens and even hundreds of columns. In this case "Fixed object height" can help you. With this option, all your tables and views will be constrained to only 15 columns on the diagram. You will still see all the existing columns in the Explorer panel and in the Table properties.

Please go to you Diagram Properties ==> View Mode Options ==> Fixed Object Height ==> check/uncheck depending on your needs.

See the screenshot below:

With the interactive three-button menu, tables can be expanded to their complete length, without disabling the FOH option or having to edit the table.

Object Groups

Groups let you group related objects on a diagram into a labeled, colored box (e.g., a business domain such as Sales, Finance, or Reference Data). On large diagrams with hundreds of tables, groups make the overall structure easy to read: collapse the domains you are not working on, and the diagram is reduced to a handful of clearly labeled areas.

Groups are a purely visual, diagram-level element. They are not database objects: they have no effect on your model, schemas, or generated DDL, and they never appear in the DDL or in an alter script.

Groups are scoped to a single diagram

A group belongs to the diagram it was created on. It is not attached to the objects themselves at the project level, so grouping tables on one diagram does not group them anywhere else.

A group and its membership exist only on the diagram where you created them. Adding the same table to another diagram does not bring its group along.
An object can belong to at most one group on a given diagram. The same object may sit in a different group (or in none at all) on another diagram.
To reuse a group on another diagram, copy and paste it. Select the group, copy it, and paste it into the target diagram. The group and its objects are recreated there. From that point on, the two groups are independent: renaming, recoloring, or changing the membership of one does not affect the other.

Creating a group

You can create a group in either of two ways:

From a selection — select the objects you want to group, then create a group from the selection. The group is drawn around them and they become its members.
Empty, then filled — add an empty group to the canvas and drag objects into it.

Working with groups

Drag an object into a group to add it.
To remove an object, right-click on it and select "Remove from group". This is also possible as a bulk action.
Objects keep the positions you gave them inside a group.
Applying an auto-layout to the diagram applies it to all objects and groups (including objects inside groups).
Objects within a group can use auto-layout without affecting the rest of the diagram
Moving a group moves all of its objects with it, so you can reposition a whole domain in one drag.
Deleting or ungrouping a group does not delete the objects inside it. They stay on the diagram and in the project.

Collapsing and expanding

Each group can be collapsed to a compact shape showing only its label, and expanded again with every object restored to its previous position. Collapse the domains you are not working on to cut down visual noise, and expand the one you need.

Relationship lines

Collapsing a group also tidies up its relationship lines, so the diagram reads at the domain level instead of showing a web of individual connections:

All relationships between the group's members and a single outside object (or another collapsed group) merge into one line drawn to the collapsed group.
Relationships between objects inside the same collapsed group are hidden.
Expanding the group restores the individual relationship lines.

Label and color

Every group has an editable text label. Use it for the domain or grouping name, such as "Sales". You can also assign a color to a group to make domains easy to tell apart at a glance. group colors follow the same color palette used elsewhere in the diagram.

Pan and zoom for trackpad and mouse

By default, the scroll wheel (and two-finger move on trackpad) will zoom the diagram.

To enable panning and zooming, and zoom via Ctrl+Scroll, enable the setting here:

Manage canvas area

Click on the Diagrams icon, or the Side Panel icon to toggle their visibility on the grid. If they're visible, you can drag the boundary to adjust the diagram area.