Naming Rules
Introduction
Section titled “Introduction”This analysis group contains object naming related analysis rules.
Naming Rules
Section titled “Naming Rules”Related Topics
Section titled “Related Topics”SA0014 : Avoid ‘fn_’ prefix when naming functions
SA0015 : Avoid ‘sp_’ prefix when naming stored procedures
SA0042A : Avoid using special characters in object names
SA0042B : Avoid using special characters in object names
SA0043A : Avoid using reserved words for type names
SA0043B : Avoid using reserved words for type names
SA0061A : Check all Tables in the current database for following specified naming convention
SA0062A : Check all Functions in the current database for following specified naming convention
SA0063A : Check all Views in the current database for following specified naming convention
SA0063B : Check view names used in CREATE VIEW statements for following specified naming convention
SA0065A : Check all Triggers for following specified naming convention
SA0066A : Check all Columns for following specified naming convention
SA0074A : Check all Schema-s in the current database for following specified naming convention
SA0075 : Avoid constraints created with system generated name
SA0066B : Check all Columns for following specified naming convention
SA0067B : Check all Unique Key Constraints for following specified naming convention
SA0071B : Check all Foreign Key Constraints for following specified naming convention
SA0072B : Check all Non-Key Index for following specified naming convention
SA0073B : Check all User-Defined Types for following specified naming convention
SA0074B : Check all Schema-s for following specified naming convention
SA0075B : Avoid adding constraints with default system generated name
SA0114 : Duplicate names of objects found
SA0114B : Object with the same name but different type already exists
SA0140 : Reserved keyword is not in the required case
SA0159 : Deprecated use of object name containing only # characters
SA0160 : Deprecated use of @, @@, or names that begin with @@ as Transact-SQL identifiers
SA0230 : Identifier uses different case than object’s actual name
SA0231 : The used parameter or variable has different case than its declaration
SA0241 : Check transaction and savepoint names for following specified naming convention