Diagramming your SQL databases

SQL Server includes the ability to create a graphical diagram of your database. You can use this diagram to view the structure of all tables in the database, as well as links between the tables in the database.

SQL Server displays the primary key-foreign key link between tables.

To create a database diagram, open SQL Server Enterprise Manager. Expand the database on which you want to create the diagram. Right-click on the Diagrams object, then choose New Database Diagram. You can then select some or all of the database's tables to include in the diagram. You can save the diagram so that you can retrieve it at a later date. In addition, you can print the diagram to document the structure of your database.

Source: Rozanne Murphy Whalen
Viewed 6690 times