Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

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.

share|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
add comment

Try out ApexSQL Search

ApexSQL Search is a FREE SQL Server Management Studio and Visual Studio add-in that, among other features, has the View Dependencies feature. The View Dependencies feature has the ability to visualize all SQL database objects’ relationships, including those between encrypted and system objects, SQL server 2012 specific objects, and objects stored in databases encrypted with Transparent Data Encryption (TDE)

The View Dependencies feature also allows you to set up and customize the visual dependencies diagram layout, including the relationships that will be presented, the layout and size of the generated diagram, and the drill-down depth of the dependencies

Disclaimer: I work for ApexSQL as a Support Engineer

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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