Database Diagram Tool for SQL Server

This page provides more detailed information about database diagram tool provided by dbForge Studio for SQL Server


Database diagram tool allows you to:

  • Visualize a database structure for further analysis
  • Cluster logically related objects using containers
  • Track logical relations between tables
  • Print out large SQL database diagrams
  • Create and edit database objects on a diagram

You can create a new SQL Server database diagram simply dragging your database objects from Database Explorer to the diagram. Your new SQL database diagram will reflect all objects and existing connections simplifying further analysis.

Visualization Tools

Simple skin type

Notations. You can choose the syntax between two common data modelling notations:

  • Information Engineering (IE)
  • IDEF1 Extended (IDEF1X)

Relation comments. You can either enable or disable the rendering of foreign key names near the relation child ends.

Skin type. There are three predefined skins:

  • Default skin — uses the richest color palette
  • Simple skin — is optimized for printing and does not use gradients
  • IDEF1X skin — is mostly black-and-white to look like IDEF1X diagrams

Document outline window shows a logical structure of the currently opened SQL diagram. You can use it to navigate between tables and their connections on a database diagram.

Diagram overview window allows you to get a better overview of large diagrams. Using this window you can:

  • Zoom in and out the diagram, to see required diagram items
  • Move to required diagram items

Other visualization options. You may hide constraints, indexes, and triggers compartments, change its field detail level to display only column names, names with types, or names with full types.

Clustering logically related objects using containers

Objects that are stored in a container

Container. In case you work with a large SQL database diagram, a container allows you to store logically related objects in one place. You can create a new container, put related tables inside, rename the container, and then collapse it.


Tracking logical relations between tables

Virtual relations between tables

Virtual relations:

  • Allows you to visualize logical relations between tables
  • Do not exist physically, they are only stored in the diagram
  • Could be used for aid in the visual analysis of the data
  • Could be materialized further into a physical relation

Virtual relation manager contains a list of existing virtual relations, and allows you to:

  • Edit existing virtual relations
  • Generate schema script taking into account selected virtual relations, edit the script, and execute it to update a database
  • Convert a virtual relation into a foreign key

Printing a database diagram

A diagram with print markup

Page options allows you to set such page settings as:

  • Page orientation
  • Paper size and source
  • Printing margins and overlapping
  • Header and footer text

Display print markup option shows you the print markup grid. Gray stripes of the grid show the page overlapping, which is adjustable.

Print options allows you to:

  • Position printed image in the center
  • Adjust diagram scale
  • Set up printing of the page markup that helps to cut and glue together the SQL diagram that is printed on several sheets

Creating and editing database objects on a diagram

Creating and editing relations that is displayed as a line between two entities in the diagram area. The context menu of this line allows you to:

  • Edit a foreign key using foreign key editor
  • Find a foreign key in database explorer
  • Synchronize with document outline window
  • Reroute a relation
  • Show a relation comment

Creating and editing objects. You can create new database objects or edit the existing ones, right in the diagram area. All the changes you have made to an object on a diagram are permanent, and stored on a server.

Note feature allows you to add comments to the diagram area, while designing or analyzing a database structure. You can also add hyperlinks inside of your note to other resources. For instance, a hyperlink to wiki pages with a database documentation.

Stamp displays the information about a database diagram, and serves to identify a printed copy of the document.

Adding of an arbitrary image to a diagram. This feature allows you to add additional visual information to the diagram area, such as a diagram sketch, or draft.

Availability

Feature Professional Edition Data Edition Standard Edition Express Edition
Database Diagram Tool for SQL Server Yes No Partial Partial

* The number of schema objects on a diagram in the Express edition is limited to 10, in the Standard edition is limited to 20.


Learn more about dbForge Studio for SQL Server and explore other features of the product.


  • SQL Manager Tool & SQL Server IDE for Developers
  • dbForge Studio for SQL Server - Development Tools
  • dbForge Studio for SQL Server - Administration Tools
  • dbForge Studio for SQL Server - Management Tools