Is there a way to generate a map of the existing tables and their relationships to each other?

Access has something like this where you view all the relationships between the existing tables, displayed as lines connecting them: k开发者_运维问答eys, 1 to many, etc. I can't find anything in ss2008 - I'm very new to it on top of that. Any help would be appreciated.

open up the database folder for the database that you are interested in, click on database diagram, click on yes when a confirmation box pops up right click on database diagrams and select new database diagram

Pick all the tables you want, click add and a diagram will be created

Now you can save the diagram, give it a useful name and it will be available next time you want to look at it