Search code examples
sql-serverentity-relationship

What is the meaning of the rhombus symbol in a SQL Server ER Diagram?

What is the meaning of the rhombus symbol in a SQL Server ER Diagram?

I have found this picture of a relationship with rhombus symbol. However in SQL Server Management Studio (SSMS) 2008, 2012 and 2014 the relationshiplines are without a rhombus. I think in 2016 and 2017 is it the same.

If there is an option, how do I turn it on to show the rhombus symbol as well.

Thanks for any hints.

enter image description here

Solution

  • This link provides information using MSFT documentation:

    Image below describes what each of those mean. While the above link provides more detail direct from MSFT docs.

    enter image description here