Search code examples
sql-serversql-server-2005ssms-2005

Relationship Diagram / Schema with selected tables

I am wondering how on Microsoft SQL Server Management Studio 2005 can i create a relationship schema with selected tables i am using on a certain part of a website i have built. I want to see what fields they have and how they are connected.

Solution

  • As Darren posted you go to your Database (I will post a graphical version here):

    enter image description here

    Then right click and select New Database Diagram

    enter image description here

    And then select the tables that you want to Add (I shall add two here):

    enter image description here

    And if there is no relationship yet you could drag from the Primary Key of another table to the Foreign Key of the related table:

    enter image description here