Skip to content

Naming Rules

This analysis group contains object naming related analysis rules.

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

SA0061B : Check table names used in CREATE TABLE statements for table name following specified naming convention

SA0062A : Check all Functions in the current database for following specified naming convention

SA0062B : Check function names used in CREATE FUNCTION statements 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

SA0064A : Check all Stored Procedures in the current database for following specified naming convention

SA0064B : Check stored procedure names used in CREATE PROCEDURE statements for following specified naming convention

SA0065A : Check all Triggers for following specified naming convention

SA0065B : Check trigger names used in CREATE TRIGGER statements for following specified naming convention

SA0066A : Check all Columns for following specified naming convention

SA0067A : Check all Unique Key Constraints in the current database for following specified naming convention

SA0068A : Check all Check Constraints in the current database for following specified naming convention

SA0069A : Check all Default Constraints in the current database for following specified naming convention

SA0070A : Check all Primary Key Constraints in the current database for following specified naming convention

SA0071A : Check all Foreign Key Constraints in the current database for following specified naming convention

SA0072A : Check all Non-Key Indexes in the current database for following specified naming convention

SA0073A : Check all User-Defined Types in the current database 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

SA0068B : Check all Check Constraints in the current sql script for following specified naming convention

SA0069B : Check all Default Constraints in the current script for following specified naming convention

SA0070B : Check all Primary Key Constraints in the current sql script 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

SA0157 : Usage of three and four part column names is deprecated. Two-part names is the standard-compliant behavior

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

SA0269 : Datatype identifier is not in the required case