-
-
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, 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.
- 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.