Skip to main content

Structure view

Switch a table to its Structure tab to see how it is built:
  • Columns - name, type, nullability, default, and keys.
  • Indexes - including uniqueness.
  • Foreign keys - relationships to other tables.
  • Triggers - where the engine supports them.
Structure view

ER diagram

Open the Diagram tab to see your tables and their relationships as an entity-relationship diagram, a quick way to understand an unfamiliar schema. Auto-generated ER diagram
Foreign keys become lines. Relationships detected in the schema are drawn automatically.
You can export the diagram as PNG, SVG, or DBML.