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?
The dotted/dashed line means, that SQL Server does not enforce referential integrity for this relationship. Have a look here
referential integrity is not enforced
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With