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.
Viewing the structure and the diagram is free. Exporting the diagram (PNG, SVG, or DBML) is a PRO feature.