Share via

Can't see table relationship while create ER diagram for SQL database

Ken 21 Reputation points
2020-08-21T05:03:50.24+00:00

Hi There,

I'm trying to generate ER diagram for one the SQL database. When selecting tables, I can see only tables but can't see table relationship.

Please help me.

Regards,

Ken

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,861 questions
0 comments
Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2020-08-21T07:15:25.127+00:00

    Hi Ken,

    As Olaf mentioned, please make sure you have created Primary/Foreign key relationship between your tables. The Database Diagram automatically and clearly show the relationship between the tables if Primary/Foreign key relationship does exist.

    Please refer to the following articles which might help:

    Create a Relationship in SQL Server 2017
    Primary and Foreign Key Constraints
    Getting started with SQL Server database diagrams

    Best Regards,

    Amelia

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,011 Reputation points
    2020-08-21T06:14:35.947+00:00

    can't see table relationship

    Have you defined Primary/Foreign key relation in your tables? Without the design can't know the relations.

    Olaf

  2. Ken 21 Reputation points
    2020-08-27T06:09:00.983+00:00

    Thanks Everyone.

    Regards,
    Ken

    0 comments