We recommend and use Red-Gate SQL Doc to produce chm help files or html pages of the database schema. SQL Doc also allows you to run via the command line so you can include the generation in your build process to be automatically created.
We have also have used other available tools in the past, such as Apex SQL Doc.
Alternatively, you can use SQL Management Studio to generate a Database diagram.
1. Connect to your database using SQL Server Management Studio
2. Create a new Database Diagram, by right-clicking Database Diagrams
Figure: New Database Diagram
3. A popup will appear. Shift-Click to select all the tables then click Add
Figure: Selecting tables for diagram
4. You will see tables populate behind the dialogue box, once complete click Close
Figure: Tables populated
5. Click off the tables in the diagram and Ctrl+A to Select all
6. Right-Click one of the tables in the diagram and perform the following
a. Select Table View | Standard from the menu
b. Select Autosize Selected Tables from the menu
Figure: Changing the database table diagram to Standard View and Autosize
7. Right-click the diagram background and select Show Relationship Labels
Figure: Show Relationship Labels
8. Move the tables around so that the Relationship Labels are clearly visible.
Note: You will need to screenshot the diagram as using the copy to clipboard function removes the “Allow Nulls” checkmarks.
Figure: Northwind Database Schema