CODEWITHSUNDEEP
sql-serversql-server-2005ssms-2005
Paul Kirkason
Paul Kirkason

Reputation: 247

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.

Upvotes: 1

Views: 890

Answers (1)

Edper
Edper

Reputation: 9322

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

Upvotes: 3

Related Questions