Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

ERD plugin manual

Paweł Salawa edited this page Dec 17, 2025 · 32 revisions

Entity-Relation Diagram

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

Usage

  • 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 Delete key to delete selected entitites (DROP tables) or relations (ALTER tables).
  • Use Ctrl+F (Cmd+F on 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 Esc key (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.
[画像:image]
  • Use keys Ctrl+1, Ctrl+2 and Ctrl+3 (Cmd+... on MacOSX) to toggle between three modes of foreign key lines (straight, curved, square).
  • Use F5 to 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).

Clone this wiki locally

AltStyle によって変換されたページ (->オリジナル) /