Rules tagged with: Naming SQL
Naming conventions for SQL objects and identifiers.
All 19 check SQL or PL/SQL code (G- codes). Browse the rules below for explanations, examples and recommended fixes.
Most severe Naming SQL rules
- G-9201 Always follow naming conventions for tables. Minor
- G-9202 Always follow naming conventions for table/view columns. Minor
- G-9203 Always follow naming conventions for indexes. Minor
- G-9204 Always follow naming conventions for primary key constraints. Minor
- G-9205 Always follow naming conventions for unique constraints. Minor
- G-9206 Always follow naming conventions for foreign key constraints. Minor
All 19 Naming SQL rules
-
G-9201 Always follow naming conventions for tables.Minor Maintainability
-
G-9202 Always follow naming conventions for table/view columns.Minor Maintainability
-
G-9203 Always follow naming conventions for indexes.Minor Maintainability
-
G-9204 Always follow naming conventions for primary key constraints.Minor Maintainability
-
G-9205 Always follow naming conventions for unique constraints.Minor Maintainability
-
G-9206 Always follow naming conventions for foreign key constraints.Minor Maintainability
-
G-9207 Always follow naming conventions for check constraints.Minor Maintainability
-
G-9208 Always follow naming conventions for assertions.Minor Maintainability
-
G-9209 Always follow naming conventions for global temporary tables.Minor Maintainability
-
G-9210 Always follow naming conventions for views.Minor Maintainability
-
G-9211 Always follow naming conventions for sequences.Minor Maintainability
-
G-9212 Always follow naming conventions for synonyms.Minor Maintainability
-
G-9213 Always follow naming conventions for triggers.Minor Maintainability
-
G-9214 Always follow naming conventions for PL/SQL packages.Minor Maintainability
-
G-9215 Always follow naming conventions for functions.Minor Maintainability
-
G-9216 Always follow naming conventions for procedures.Minor Maintainability
-
G-9217 Always follow naming conventions for object types.Minor Maintainability
-
G-9218 Always follow naming conventions for object type attributes.Minor Maintainability
-
G-9219 Always follow naming conventions for collection types.Minor Maintainability
19 total
More ways to browse rules
- Trivadis PL/SQL & SQL guideline rules - Rules that implement the Trivadis coding guidelines.
- OWASP-related security rules - Rules that name an OWASP Top 10 risk category.
- Oracle APEX rules - Checks for APEX applications, pages, items and regions.
- PostgreSQL rules - Rules that also apply to PostgreSQL and PL/pgSQL.
- Security rules - All rules in the Security quality area.
- Reliability rules - Rules that prevent bugs and failures at run time.
- Maintainability rules - Rules for code that is easy to read and change.
- Rules by quality area - Security, reliability and maintainability.
- Rules by severity - From Blocker to Info.
- Rule profiles - Essential to Extreme: which rules are checked.
- All rules - Search and filter the complete rule set.