Do you use a SQL Server Relationship Naming Standard?
Updated by Jayden Alchin [SSW] 3 years ago. See history
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.
Acknowledgements
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.