No rule selected
G-9206 – Always follow naming conventions for foreign key constraints.
All table constraints share the same namespace. Follow naming conventions to prevent naming conflicts, improve readability, and clearly indicate the scope without forcing the use of qualified names. A common practice is to use a prefix and/or suffix to distinguish the identifier types. **Recommendations** Table name/abbreviation followed by referenced table name/abbreviation followed by a `_fk` and an optional number suffix. **Examples** * `empl_dept_fk` * `sct_icmd_ic_fk1`
Tags: Naming SQL.
Quality area: Maintainability. Severity: Minor. Fixing time: Local-high.
Press p or n to quickly navigate to the previous/next rule.
