What does a dashed / dotted relationship line represent in SQL Management Studio - Database Diagram

Question

I'm looking at an existing database in Microsoft SQL Server Management Studio, and in the Database Diagram there is one relatioship that appears with a dashed or dotted line. The other relationships are all solid lines. What does the dashed line mean?

enter image description here

score 9 · Accepted Answer · edited Feb 19 '12 at 09:23

9

The dotted/dashed line means, that SQL Server does not enforce referential integrity for this relationship. Have a look here

edited Feb 19 '12 at 09:23

MattyG

8,449
6
44
48

answered Feb 19 '12 at 09:05

Mithrandir

24,869
6
50
66

score 2 · Answer 2 · answered Feb 19 '12 at 09:08

2

referential integrity is not enforced

answered Feb 19 '12 at 09:08

Simon Thompson

708
6
14

What does a dashed / dotted relationship line represent in SQL Management Studio - Database Diagram

2 Answers2

Linked