up vote 0 down vote favorite
share [g+] share [fb]

In SQL Server Management Studio, I have relationships set up between tables.

Is there a way to display a view of all the tables with the adjoining lines like in Microsoft Access? Do I need to open a new query and run something or is there a button that I've missed?

link|improve this question
0% accept rate
feedback

1 Answer

up vote 1 down vote

If you are using Management Studio 2008 :

Expand the root Database, try and expand the Database Diagrams folder, it should say something like "no diagrams".

If it asks you to create a diagram say yes, then add the tables and voila!

If not, right on Database Diagrams folder and create new Diagram.

link|improve this answer
That is very helpful, but I don't want to create a diagram, I want to see the current relationships between tables. If I create a diagram, it's just whatever I put on the diagram... – LtDan Jul 13 '11 at 20:11
If you create the diagram and add your tables, it automatically adds the relationships..... like in access. Try it – leinad13 Jul 14 '11 at 14:41
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.