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

sql database sql-server-2008 ssms database-diagram
MattyG picture MattyG · Feb 19, 2012 · Viewed 22.7k times · Source

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

Answer

Mithrandir picture Mithrandir · Feb 19, 2012

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

Related questions

Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
how to schedule a job for sql query to run daily?

I need to know how to make a SQL query run daily using a SQL Server Agent job, with minimum required configuration settings.

Read More
Querying data by joining two tables in two database on different servers

There are two tables in two different databases on different servers, I need to join them so as to make few queries. What options do I have? What should I do?

Read More