DataBase/Tables Relationship View

  • Hi, Can somebody tell me how to look at a visual representation of the relationships between tables, and primary keys etc? I liked this feature in Access, but can't seem to see it in SQL 2005. ( I do see the Database Views option in the Explorer window, but when I click on it, nothing populates or changes.)

    TIA.

  • That is where you will see VIEWS that you (or developers) create in the database. What you are probably wanting to look at is the database diagrams. You will have to create those manually once you install the tools to support database diagrams(will be done when you expand the database diagrams and answer Yes).

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply