Skip Navigation LinksHome > SSW Standards > DeveloperSQLServer > SSW SQL Server Relationship Naming Standard

What others have to say about us
See what people think about this product I've been putting together Development Guidelines for my employer and in the process have reviewed many published standards (in the .Net arena) from around the world. In each category, the suggestions at SSW are always among the best. See what people think about this product
- Leon Bambrick,
  SQL Server Relationship Naming Standard

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.

Examples

Rather than accepting the default value i.e. ClientAccount_FK01 that is given from upsizing.

We recommend using Prod-ClientAccount.

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

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

Acknowledgments

Adam Cogan