The info panel is attached to the right of the ERD canvas. Here you save or delete the ERD, set its name and display options, and find or remove the tables it includes. How saving differs from applying changes to the database is explained in ERDs and the real database.
What's on the screen
| No. | Name | Description |
|---|---|---|
| 1 | Save button | Saves the ERD, and the design of tables you changed in it, to the project. You can't click it when nothing has changed. Same as Ctrl+S (Cmd+S on macOS). |
| 2 | Delete button | Deletes this ERD. It doesn't delete tables in the real database. For a team ERD, it appears only if you have permission to delete. |
| 3 | Connection and schema labels | The connection and schema the ERD belongs to. For a DBMS with a database layer, the database is shown too. An ERD created with All (allow all schemas) shows All (All Schemas). If the labels overflow, scroll them sideways with the mouse wheel. |
| 4 | ERD Name field | The ERD's name. After editing it, leave the field and it is saved right away. |
| 5 | Type | Shows whether this is a Personal or Team ERD, and whether it is published to the gallery (Published). ERDs in a local project are always personal. |
| 6 | Zoom out switch | When on, tables show only their names, in large type, when you zoom the canvas far out. When off, columns are shown at every zoom level. |
| 7 | Schema switch | Shows each table's schema name above the table. It starts on for an All (allow all schemas) ERD and off for an ERD of a single schema. |
| 8 | Apply Changes to DB... button | Opens a dialog that previews, as DDL, the changes to tables in this ERD not yet applied to the database, and runs them. See Apply changes to the database. |
| 9 | More button | Menu with the Start Team Sharing & Collaboration... and Publish to Public... items. See 'Start Team Sharing & Collaboration and Publish to Public' below. |
- Click the arrow button on the panel's left edge to fold the panel and give the canvas more room. Click it again to unfold.
- The Apply Changes to DB... button appears only on an ERD with a connection, and you can click it only when the connection has database connection details and there are changes to apply to the database.
Set Column Display
In the Column Display part, you decide what tables on the canvas show and in which order.
| No. | Name | What it does |
|---|---|---|
| 1 | Physical mode and Logical mode buttons | Choose whether tables and columns show their physical or logical names. Only the names shown change, not the tables. In logical mode, a column with no logical name shows its physical name dimmed. |
| 2 | Show opposite name on table header | Shows the other mode's name next to the current mode's name in each table header. It starts off. |
| 3 | Column item list | The column items shown inside tables (Key, Logical Name, Column Name, Data Type, Default Value, Comment and so on). Uncheck an item to hide it, and drag its handle to change the order. If the connection has no domain assigned, the Domain item doesn't appear. |
- Which column items are shown, their order, and the Show opposite name on table header setting are stored separately for physical mode and logical mode. Switching modes switches to that mode's settings.
- If you choose logical mode and the connection has no data dictionary assigned, the A data dictionary is recommended for logical mode. notice appears. You can still write and see logical names without a dictionary. Click the Set a dictionary in connection settings link next to the notice to open the connection dialog where you assign one (Data dictionary).
- Changing this part leaves unsaved changes in the ERD. Click the Save button to keep them.
Work with included tables
The Included Tables part lists every table in this ERD. The number next to the title (1) is the table count; while you search it changes to matches/total.
- Type part of a table name or comment in the search box (2). Only tables containing that text remain.
- Click a table row (3) once to select that table on the canvas and bring it to the middle of the view. The Table detail panel opens below the canvas. Double-click to zoom so the table fills the view.
- To take a table out of the ERD, click the Remove from ERD button (4) at the end of its row. The table in the real database stays as it is.
- Right-click a table row for the same menu you get when you right-click the table on the canvas (Table node).
- A table marked for deletion shows the Pending deletion label. It is dropped from the database at the next apply.
- A table the project can no longer find shows as Unknown Table. If you don't need it, click its Remove from ERD button.
Start Team Sharing & Collaboration and Publish to Public
The items in the More menu work only when you are signed in and have an account project open. Otherwise the menu still appears, but its items carry a lock.
- Click the locked Start Team Sharing & Collaboration... item (1) and NeoSQL tells you what it needs. If you aren't signed in, it says the feature works after you sign in, in an account project; if you are signed in but the project is local, it says the feature works in account projects only.
- Click the locked Publish to Public... item (2) and the Publish to Gallery dialog opens in a locked state, only showing what the feature does.
- A local project can't be turned into an account project. If you need team sharing, create the ERD in an account project from the start (Sign-in and project types).
In an account project, the menu depends on the ERD's type.
| ERD | Menu |
|---|---|
| Personal ERD | Start Team Sharing & Collaboration... (2) turns it into a team ERD. Publish to Public... (3) publishes it to the gallery. Once published, Update Gallery... and Unpublish... appear instead. |
| Team ERD | Copy to My ERD makes a personal copy for you. |
- Save the ERD before turning it into a team ERD. If there are unsaved changes, the Save the ERD before starting team sharing. notice appears.
- An ERD tied to a private connection (SQLite,
localhostand so on) can't become a team ERD, so the item is dimmed. Such a connection doesn't point to the same database on your teammates' computers (Connections and execution targets). - While a personal ERD is published to the gallery, the team sharing item isn't shown.
- The difference between personal and team ERDs is explained in Collaboration and permissions, and publishing in Gallery and embedding.
Where settings are stored
The info panel's settings are stored in two places. What is stored in the ERD document is shown the same way to teammates who open the same ERD; what is stored on this device applies only to you, to every ERD on this device.
| Setting | Stored in |
|---|---|
| ERD Name | The ERD document (saved right away) |
| Display mode, the Show opposite name on table header option, which column items are shown and their order | The ERD document (saved with the Save button) |
| The Included Tables list and their layout | The ERD document (saved with the Save button) |
| Zoom out, Schema | This device (as soon as you change them, for every ERD) |
Things to keep in mind
- The Remove from ERD and Delete buttons don't change the real database. How to drop a table in the database is explained in ERDs and the real database.
- In an account project, if your role has the DDL Restriction permission turned on, the Apply Changes to DB... button turns orange and only tables you changed are applied. The flow in that case is explained in Apply changes to the database.
- For a team ERD, the Delete button is hidden without the All Permissions or ERD Delete Permission permission, even for the person who created it.
Related screens
- ERD canvas: the workspace the info panel is attached to.
- ERD and SQL list: create, find and delete ERDs.
- Apply changes to the database: the dialog that previews and runs DDL.
- Export as image: save an ERD as a PNG or SVG image.
- Gallery and embedding: publish a personal ERD to the gallery.