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?
Solution
The dotted/dashed line means, that SQL Server does not enforce referential integrity for this relationship. Have a look here
- DateTime2 vs DateTime in SQL Server
- Generate Dates between date ranges
- Why (and how) to split column using master..spt_values?
- Oracle-DB, Joining 3 Tables Limiting the second without using LATERAL() or nesting
- How to convert sql table into a pyspark/python data structure and return back to sql in databricks notebook
- Get rendered SQL from CodeIgniter active record script
- Materialized view in Marketing Performance DB in Azure SQL database
- mysql delete under safe mode
- SQL SELECT WHERE field contains words
- SQL Server: group dates by ranges
- Get day of week in SQL Server 2005/2008
- The table has no ID, the date is contained in two columns
- Creating an index on a table variable
- How to drop all tables except 1
- Pyspark: Select all columns except particular columns
- How do I grant read access for a user to a database in SQL Server?
- MariaDB : create database and execute sql script without '<' character from the command line cmd.exe
- Find records with only one id
- MySQL - Get the first and last day of previous week
- Implementing iteration in Standard SQL (BigQuery)
- Concatenate dataframes in a loop where some of them may have no values
- SQL update with join is only updating one column
- Nested LAG function (kind of)
- Get SQL to get all records from a usertable and those matching uids from second table or return null
- SQL query to find duplicate rows based on multiple columns
- SQL Server Add row number each group
- How to calculate FIFO in SQL using matching overlapping blocks (using JOIN instead of UNION)
- How do I spool to a CSV formatted file using SQLPLUS?
- what is a foreign key and why you use it?
- What is semi-join in database?