This page provides more detailed information about database diagram tool provided
by dbForge Studio for SQL Server
Database diagram tool allows you to:
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.
Notations. You can choose the syntax between two common data modelling
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:
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:
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.
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
Virtual relation manager contains a list of existing virtual relations,
and allows you to:
Page options allows you to set such page settings as:
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:
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:
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.
* 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.
If you are an SQL Server MVP,
send us a link to your Microsoft MVP profile and get a free
licence for any SQL Server product!
" Hello, I'm a software developer from Turkey. I've been using your product for
a while and must say that I really love it. When it comes to sql programming and
other non DBA operations, I do not consider your product as an alternate to SQL
Server Management Studio, but a superior one. That's why as a Microsoft Certified
Trainer, I use your product even in my classes and many of my students also like
Tayfun Esmer, Microsoft Certified Trainer, Turkey
Read more Your testimonial
You might be also interested in:
SQL Server data access with the following technologies: