Database Diagram overview

The Database Diagram in dbForge Studio for SQL Server is a visual tool for designing and exploring database structures. It lets you create, view, and modify database objects and their relationships in a graphical environment without writing SQL manually.

dbForge Studio for SQL Server provides a full set of tools to design, document, and manage your database visually using the Database Diagram.

Design database structures

You can create a database diagram by dragging or adding database objects from Database Explorer or by building new tables, views, stored procedures, and functions directly on the canvas.

Define and manage relationships

You can create physical (foreign key constraints) and virtual relationships between tables to represent how data connects across your schema. The diagram supports creating many-to-many relationships between tables and provides relationship notation options to control how relationships are displayed.

Arrange and navigate diagrams

You can automatically arrange objects on the diagram using the layout tool, or manually drag and reposition shapes. For large diagrams, the navigation tools help you move around the canvas and locate specific objects. You can also search for text across the diagram to find objects and labels.

Annotate and document diagrams

You can enrich a diagram with additional elements, including notes, containers, images, and stamps that display metadata such as the author, version, and date. These elements help document the diagram and communicate design intent to other team members.

Control diagram appearance

You can configure diagram options and choose from different relationship notations and shape styles to match your organization’s standards or personal preferences.

Save, export, and print diagrams

You can save a diagram to a file and restore it later to continue your work. To share or archive a diagram, you can export it to an image or other supported format. You can also print a diagram directly from dbForge Studio.