Relationship Diagram / Schema with selected tables

Question

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.

In your database you have Database Diagrams - you can create a new ERD from there by right clicking -> New Database Diagram — Darren, Aug 08 '13 at 08:46

Edper · Accepted Answer · 2013-08-08T09:14:07.673

2

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

edited Aug 08 '13 at 09:14

answered Aug 08 '13 at 09:00

Edper

9,144
1
27
46

You're welcome @AndyKirkpatrick. GOD bless your quest for learning SQL server and its tools. – Edper Aug 08 '13 at 11:45

Relationship Diagram / Schema with selected tables

1 Answers1