[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MS SQL Server Database Diagram does not show table relations

Posted on 2011-05-08
7
Medium Priority
?
95 Views
Last Modified: 2015-01-15
I have a database and want to see its table relationships. I did the Create New Database Diagram operation and selected the tables I want, but it only shows the table columns but there is not arrows or lines that show inter-relationship among the tables?!

What am I missing?
0
Comment
Question by:TongZ
  • 4
  • 2
7 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 35716410
do you have foreign keys defined?
0
 

Author Comment

by:TongZ
ID: 35716413
All keys including foreign key are defined.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 35716461
have you tried to draw any new relations on your diagrams? the relations should appear automatically as there are no option to make them visible or not.

is this diagram upgraded from an earlier version of SQL Server?
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Author Comment

by:TongZ
ID: 35716597
there was no existing diagram, I am creating the first one and it is not upgrade from earlier version of SQL Server.

What I did notice is that in some of the examples, I see the schema name is in parenthesis after the table name, which I don't see on mine. Also, do I need to "Add" all tables in the DB?
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 35717644
Hi, If you have Primary-Foregnkey relation then no need to add it. Just Add table and it will automatically create links.
0
 

Accepted Solution

by:
TongZ earned 0 total points
ID: 40542219
I would like to close this question without assigning points.
0
 

Author Closing Comment

by:TongZ
ID: 40550855
This is a project related question which was a long time ago, it was not resolved but it was needed anymore for that project. Hence, would like to close the question.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question