Database Diagrams in SQL Server 2008

[JScannell]

I'm having a problem creating database diagrams. I can create a new diagram and populate it with all the tables, however, there are no relationship lines shown. In fact the table objects just appear alphabetically going left-to-right.

This does me no good as my intentiojn is to determine the relationships between over 100 tables of a database I'll be working in. I don't know the existing relationships so this tool is supposed to provide it for me.

Thanks in advance,

Jerry Scannell

 

[mrdenny]

The tool queries the database for this information. Do you have foreign keys defined in your database? I'm guessing you probably don't as that is the information that the diagram app uses to match things up.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[JScannell]

As it turned out, there were table mappings, however, they were so far down the data entry screen that I didn't see it. All I saw was a bunch of unmapped tables so I was led to believe that I couldn't do it.

I am all set now.


Jerry Scannell