• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 642
  • Last Modified:

How do you view relationships in MS SQL Server 2008 Express Edition?

Hi, I've upsized my database from MS Access 2003 to MS SQL Server 2008 Express Edition. Now, how do I view the  relationships I've made in SQL Management Studio? I was hoping it'll be like access where I can graphically view the all the tables with relationships. Thanks in advance
0
0nepiece
Asked:
0nepiece
1 Solution
 
liorfrCommented:
Choose Database Diagrams, left click new diagram and choose the objects you want to see.

That's about it,

Lior
ScreenHunter-01-Jan.-04-12.45.gif
0
 
MikeWalshCommented:
The Database Diagram functionality exists in Management Studio Express, I believe (I don't have it handy on this machine to verify)

But you should be able to create a database diagram and include relationships.
0
 
0nepieceAuthor Commented:
Ok got that! Thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now