Secret ingredients to quality software

We open source.Loving SSW Rules? Star us on GitHub. Star

© 1990-2025 SSW. All rights reserved.

FEEDBACK / SUGGEST A FEATURE|TERMS AND CONDITIONS|

This website is under CONSTANT CONTINUOUS DEPLOYMENT. Last deployed 12 minutes ago on Dec 19, 2025 at 10:10 UTC (Build # 8-0ed4115)

Powered by Azure and GitHub

SSW Rules
SQL Databases - Developers
This rule

Relationships - Do you have FOREIGN KEY constraints on columns ending with ID?

Loading last updated info...

Open in ChatGPT

Columns ending with 'ID' should have FOREIGN KEY constraints.

Figure: Missing relationships

Categories

SQL Databases - Developers

Authors

Need help?

SSW Consulting has over 30 years of experience developing awesome software solutions.