Home
General - Do you use a SQL Server Relationship Naming Standard?
  v2.0 Posted at 3/01/2020 4:36 PM by Christian Morford-Waite
​This standard outlines the procedure on naming Relationships at SSW for SQL Server. Use this standard when creating new Relationships or if you find an older Relationship that doesn't follow that standard.

​​Do you agree with them all? Are we missing some? Let us know what you think.

Syntax

Relationship names are to have this syntax:
[PrimaryTable] - [ForeignTable]
[        1       ] - [        2       ]

[1] The table whose columns are referenced by other tables in a one-to-one or one-to-many relationship.
Rather than accepting the default value i.e. ClientAccount_FK01 that is given from upsizing.

Figure: Bad Example - using the default relationship name

​We recommend using Prod-ClientAccount.

Figure: Good Example - using a more descriptive relationship name


​The good thing is when you look at the relationship from the other side it is there as well.

Figure: Relationship name shown on the other table

We also believe in using Cascade Updates - but never cascade deletes.

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: