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

Clone this wiki locally

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