-
-
Notifications
You must be signed in to change notification settings - Fork 653
ERD plugin manual
Paweł Salawa edited this page Dec 17, 2025
·
32 revisions
This plugin, introduced in SQLiteStudio 4.0.0, enables the application to visualize database schema as entities (tables) and relations (foreign keys). It also allows to edit the schema in the same (visual) manner.
[画像:image]To open ERD editor for certain database, have a database (or any object inside that database) highlighted on the databases list. Then hit the ERD editor button on toolbar:
[画像:image]If you don't have button with this icon on your toolbar, check if you have the ERD plugin loaded into SQLiteStudio (go to Configuration window, then to Plugins section).
- Hold the spacebar and drag with the mouse to scroll the diagram freely without selecting any items.
- Use mouse wheel to zoom in and out.
- Your custom arrangement of entities will be saved and restored upon next time you use ERD editor on the same database.
- Select entity (table) or relation (foreign key) line to edit its properties in the (right) side panel.
- Use
Deletekey to delete selected entitites (DROPtables) or relations (ALTERtables). - Use
Ctrl+F(Cmd+Fon MacOSX) to search for an entity by its name or the name of its column. - Deselect entity (or click Commit on side panel toolbar) to apply the side panel modifications to the diagram.
- Press
Esckey (or click Rollback on side panel toolbar) to abort the side panel modifications to the diagram. - Ultimately all changes to the diagram remain pending until you commit or roll them back using the toolbar buttons in the top-left corner of the diagram.
- Use keys
Ctrl+1,Ctrl+2andCtrl+3(Cmd+...on MacOSX) to toggle between three modes of foreign key lines (straight, curved, square). - Use
F5to abandon pending changes and reload schema from current database state (you will be asked to confirm if there are any uncommited changes pending). - Double click on relation line (foreign key line) to change its destination in a visual manner.
- If you modify database schema outside of the ERD editor, while there are changes pending for commit, the commit action will fail if external changes turn out to be incompatible.
- Committing pending changes is an atomic action - it either succeeds or fails entirely.
- You can review pending changes by clicking on the pending changes counter (next to Commit & Rollback buttons on the toolbar).