When you open a SqlDBM diagram, you can see a sidebar on the left side of the screen. We call this the Explorer panel.
Here you can see the objects that make up your database and diagrams:
• Diagrams
• Diagram explorer
• Database explorer
Diagrams
On this item, you can see a list of diagrams and classify them into folders called "subject areas."
Since databases can grow in size and complexity, it may help create diagrams for specific areas instead of one overall landscape. You can create subject areas based on business areas, data marts, or whatever makes sense for your organization.
Interact with common features, such as:
• Switching between diagrams by clicking on them in the Diagram lever on the left
• Switching between diagrams by clicking on Diagram tabs on the top of the canvas
• Creating diagrams (please note: must have a modeler role to perform this action)
Create New Diagrams
(please note: must have a modeler role to perform the following actions)
There are several ways to create a new diagram
1. Use the "Plus" icon on the right side of the subject area bar.
2. Choose objects, hold the "Ctrl (Cmd)" key, and click the "Plus" icon. That is the easiest way to add a new diagram with the chosen objects.
3. Use a context menu by diagram or subject area item in the Explorer panel.
4. Use the bottom bar of the Explorer panel.
Diagram explorer
On the diagram explorer item, you can see objects that the current diagram contains, such as tables, relationships, notes, and views.
The table object tree displays all the tables in the database, not only those present on the current diagram or subject area.
To add objects to a diagram, select the desired object, or objects if using multi-select (see below for more info), and drag to the desired place on the diagram.
Alternatively, individual objects can be added to the diagram by clicking on the "Bring to diagram" icon next to the object name. This icon appears after hovering on the desired item.
Use the context menu to create a new table, bring related tables, show or hide tables from the canvas, or delete a table.
The same features are displayed on the right side of the bottom bar.
Use the "Show schema name" icon on the left side of the bottom bar to hide or show schema name.
You can also filter your database objects by the currently selected diagram or subject area.
• By subject area. Only objects from the chosen subject area are shown in the explorer
• By diagram. Only objects, that are displayed on current diagram are shown in explorer.
Database explorer
Database explorer level includes all database objects from your project, including ones that can't be shown on the canvas (e.g., file formats or check constraints). You can view and edit them all from here.
These might be:
• schemas
• tables, including their columns, indexes, and constraints
• references
• virtual references
• views
To display object properties, click on the relevant item.
Use context menu to create a new object or remove current one. The same icons are also present on the bottom bar.
Explorer Search
You can easily search for all database objects (like tables, references, columns, and indexes) by name in the Diagram Explorer and Database Explorer panels.
Click on the "Database Explorer" or "Diagram Explorer" icons from the left pane and find the search window on the top left.
These screens will display all database objects and allow you to search using the same wildcard match functionality.
The wildcard match of the search term will look for matches in all objects listed in the explorer menu:
Locate on diagram
Which diagram has the table I'm looking for? Diagram Explorer and Database Explorer panels provide a "Locate on diagram" feature to help you jump directly to any diagram of interest. Combined with the "Search" feature mentioned above, locating and navigating to a desired project object has never been easier.
Multi-select and bulk edit
Users can multi-select objects from the database and diagram explorer by holding the Ctrl (⌘/command on Mac) key while clicking on multiple objects.
Bulk actions, such as coloring, schema selection, and others are available from the right-hand properties panel.
The context menu for multi-selected objects allows users to perform bulk actions like bringing to diagram or deleting multiple objects.
Hide and show the Explorer panel
Use the icon near the explorer name to hide the panel. To display it, click on the icon in the left sidebar.
See also