Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

like image 411
MattyG Avatar asked Feb 19 '12 08:02

MattyG


2 Answers

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

like image 67
Mithrandir Avatar answered Sep 17 '22 23:09

Mithrandir


referential integrity is not enforced

like image 21
Simon Thompson Avatar answered Sep 17 '22 23:09

Simon Thompson