-
-
Notifications
You must be signed in to change notification settings - Fork 653
ERD plugin manual
Paweł Salawa edited this page Dec 16, 2025
·
32 revisions
This plugin enables SQLiteStudio 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.
- Help yourself with auto-arranging of newly open database, so it makes more sense: image
- 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
Ctrl+Fto 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
1,2and3to 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.