Microsoft® SQL Server 2012 Unleashed

Using Database Diagrams to Create Tables

You can use the database diagrams for a more robust visual representation of your tables. You view them from within SSMS, and they give you the distinct advantage of being able to display multiple tables and the relationships between these tables. The Database Diagram Editor behaves similarly to other data modeling tools that allow you to move related tables around in the diagram and group them accordingly.

Figure 20.2 shows several screens related to database diagrams. The left side of Figure 20.2 shows the Object Explorer and the resulting New Database Diagram option that is displayed if you right-click the Database Diagrams node. The right side of the screen shows the diagram design window. In this ...