rules repository

G-9202 – Always follow naming conventions for table/view columns.

SQL identifiers share the same namespace as PL/SQL identifiers. 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** Singular name of what is stored in the column (unless the column data type is a collection, in this case you use plural names). Add a comment to the database dictionary for every column. See also [G-1270](https://dblinter-rules.united-codes.com/rules/G-1270/).

Tags: Naming SQL.

Quality area: Maintainability. Severity: Minor. Fixing time: Other.

No rule selected