Working with Database Diagrams
You can create a visual diagram of your database using the Database Designer. The following topics cover the basics of using the designer to work with database diagrams.
You can use the Database Diagram Designer to update databases in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. However, SQL Server 2012 doesn't support this feature.