Tables / Columns
Learn how to create, view, edit, and delete tables and columns in the ERD.
Add Table
Add a new table to the ERD canvas.
Click Add Table Button
Click the "Add Table" icon in the ERD toolbar. Once the button is active, the next canvas click creates a table at that position.
Click Canvas Position
Click an empty area where the table should be placed. A new table is created in the ERD connection/schema and displayed as a node on the canvas.
| Add Path | Method |
|---|---|
| Add from ERD canvas | Click the Add Table icon in the left toolbar, then click an empty canvas area |
| Add from ERD context menu | Right-click an empty canvas area, choose "Add New Table", then click an empty canvas area |
| Add from schema tree | Right-click the schema/table area in the left tree and choose "New Table". The new table opens in a detail tab. |
Note: New tables are named with a non-duplicated default such as table1 or table2. If the ERD has a single schema it is used automatically; if multiple schemas are allowed, a schema selection dialog may appear.
Add & Edit Columns
Add columns to a table and configure their properties.
Select Table
Click a table node in the ERD. The selected table's column grid becomes editable and the top toolbar shows save, restore, apply-to-DB, and detail-tab actions.
Add Column
Click the + button in the header at the far right of the column grid. If a row is focused, press Cmd + Enter on Mac or Ctrl + Enter on Windows to add a new column below the current row.
Set PK
Select the PK checkbox for columns to be used as the Primary Key. PK columns are automatically set to Not Null, and N/N cannot be unchecked for them.
Column Add Methods
| Location | Method | Insert Position |
|---|---|---|
| ERD table node | Click the + button in the header at the far right of the column grid | Added as the last column |
| ERD column cell | Cmd + Enter / Ctrl + Enter | Added below the selected/focused row |
| ERD table header | Cmd + Enter / Ctrl + Enter | Added as the last column |
| Table Columns in the detail tab | Click the "new column" button | Added as the last column |
Editable Column Fields
| Field | Description |
|---|---|
| Column | Enter the column name directly. Duplicate names within the same table are not applied. |
| Data Type | Choose from DBMS-specific data types or enter a custom type. ENUM/SET types support a separate value editor. |
| PK | Sets whether the column is part of the Primary Key. The change is tracked as a table PK change. |
| N/N | N/N means Not Null. When checked, the column is saved as nullable=false. |
| A/I | Sets whether the column is auto-incremented. Default value editing is disabled for auto-increment columns. |
| Default Value | Enter the default value. This is unavailable for auto-increment columns. |
| Remarks | Enter the column comment/description. |
- New columns are created with a non-duplicated name such as column1 or column2 and the DBMS default string type.
- For existing tables, if the DBMS does not support column reordering, new columns can only be inserted within the new-column area, not between existing columns.
- When PK is checked, Not Null is applied automatically, so you do not need to check N/N separately.
Advanced Column Actions
| Action | Method | Note |
|---|---|---|
| Reorder columns | Drag the row handle on the left side of the selected table's column rows | All columns can be reordered for new tables or DBMSs that support column reordering. For existing tables on unsupported DBMSs, only newly added columns can be moved within the new-column area. |
| Delete selected columns | Delete / Backspace or use "Delete Columns" from the context menu | If a column is used by an FK, a confirmation dialog appears for deleting the related FK. For composite FKs, review any other columns that will be affected. |
| Configure displayed column fields | Use checkboxes and drag ordering in the right ERD info panel's column display settings | Controls which column fields are visible on ERD nodes and their order: key, name, type, PK, N/N, A/I, default value, and remarks. |
| Resize column display width | Drag column header borders in the ERD node grid | Column widths are saved per table and preserved when the ERD is opened again. |
View Table List
View the list of tables in the database connected via the connection.
You can filter tables by name using the search bar at the top of the table list.
View in Detail Tab
When you select a table, a detail tab opens at the bottom. In the detail tab, you can view and edit detailed information such as columns, indexes, FK, and data.
| Area | Content |
|---|---|
| Database Table Information | Schema, table name, description, engine/charset, and other basic table information |
| Table Columns | Column name, type, PK, N/N (Not Null), A/I (Auto Increment), default value, comments - view/edit |
| Foreign Keys | View, add, and delete FK list |
| Indexes | View, add, and delete index (including Unique) list |
Table Actions
Select or right-click a table in the ERD to run table-level actions.
| Action | Method | Effect |
|---|---|---|
| Open detail tab | Click "View in Detail Tab" in the selected table toolbar or context menu | Edit table info, columns, FKs, indexes, and constraints in the bottom detail tab. |
| Save | Click Save in the selected table toolbar or context menu | Saves table changes to the current project store. The database is not changed yet. |
| Restore | Click Restore on a changed table or use the context menu | Reverts the table to the last saved state. Unsaved table/column edits are discarded. |
| Pull table info | Run "Pull Table Info" on an existing table | Loads the latest metadata from the database. Local changes are handled according to the selected merge/replace policy. |
| Apply changes to DB | Run "Apply Changes to DB" on a changed table | Generates and executes CREATE/ALTER/DROP DDL against the actual database. |
| Remove from ERD | Delete / Backspace or use the close icon in the table header, or "Remove from ERD" in the context menu | Removes only the node from the current ERD canvas. The table remains in the schema. |
| Delete table | Click "Delete Table" in the selected table toolbar or context menu | New tables are removed from the internal store. Existing tables can be marked as deleted or dropped with DROP TABLE. |
Note: Delete/Backspace first deletes selected column rows when any are selected; otherwise it removes the selected table from the ERD. Use the "Delete Table" action for actual table deletion.
Save / Restore Table
You can save table structure changes made in the ERD to the current project without applying them to the database.
When there are unsaved changes in a table, the restore button becomes active. Click it to revert to the last saved version.
Apply to Database
Apply the table structure designed in the ERD to the actual database.
Select the changed tables and run the apply to database function. CREATE/ALTER DDL will be auto-generated and applied to the database.
Copy / Paste Tables & Columns
In the ERD, you can copy or cut tables and columns, then paste them within the same connection and schema.
Copy / Cut / Paste Tables
| Action | Shortcut | Context Menu |
|---|---|---|
| Copy table | Cmd/Ctrl + C | Copy Table |
| Cut table | Cmd/Ctrl + X | Cut Table |
| Paste table | Cmd/Ctrl + V | Paste Table |
- Use Ctrl/Cmd + click to select multiple tables and copy or cut them together.
- Cutting a table removes it only from the source ERD after paste completes. It does not immediately delete the source schema table.
- If copied tables have FKs, you can choose whether to include FK relationships during paste. Name conflicts are avoided automatically.
Copy Columns
Select Columns
Click on the columns you want to copy in the table node's column grid. Hold Shift or Ctrl/Cmd to select multiple columns.
Execute Copy
Press Cmd/Ctrl + C, or right-click and select Copy Columns from the context menu.
Cut Columns
Select columns, then press Cmd/Ctrl + X or select Cut Columns from the context menu. The original columns will be deleted from the source table after pasting.
Paste Columns
Select Target Table
Click on the target table in the ERD canvas where you want to paste the columns.
Execute Paste
Press Cmd/Ctrl + V, or right-click the target table and select Paste Columns.
Choose Whether to Include FK
If the copied columns have associated Foreign Keys, a dialog will ask whether to paste the FK relationships as well.
| Action | Shortcut | Context Menu |
|---|---|---|
| Copy | Cmd/Ctrl + C | Copy Columns (N) |
| Cut | Cmd/Ctrl + X | Cut Columns (N) |
| Paste | Cmd/Ctrl + V | Paste Columns (N) |
Note: Column copy/paste only works within the same connection and schema. You cannot paste columns into tables from a different connection or schema.
- If a column with the same name already exists in the target table, a "_copy" suffix is automatically added (e.g., name → name_copy → name_copy_1).
- When pasting with FK included, FK names are automatically generated to be unique within the schema.
- Pasted columns are appended to the end of the target table.
Delete
Delete a table or column.
| Target | Delete Method |
|---|---|
| Table | Select the table, then choose "Delete Table" |
| Column | Click the delete (-) button on the column row in column editing mode |
Note: When you delete a table that has relation lines connected, those relation lines are also deleted. For tables with FK relations, you must first remove the FK from the referencing table before deleting.
