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 24.2 shows several screens related to database diagrams. The left side of Figure 24.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 ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.