SA0014 : Avoid ‘fn_’ prefix when naming functions |
![]() |
The topic describes the SA0014 analysis rule.

Avoid ‘fn_’ prefix when naming functions

This rule checks for user defined scalar functions with ‘fn_’.
Though this practice is supported, it is recommended that the prefixes not be used to avoid name clashes with Microsoft shipped objects.

Do not use the ‘fn_’ prefix when naming the function.

The rule has a Batch scope and is applied only on the SQL script.

Rule has no parameters.

The rule does not need Analysis Context or SQL Connection.


Naming Rules, Bugs

There is no additional info for this rule.

SQL
1CREATE FUNCTION dbo.fn_myfunction 2( 3 @value AS int 4) 5RETURNS int 6WITH EXECUTE AS CALLER 7AS 8 BEGIN 9 SET @value=@value + 1 10END; |

Message | Line | Column | |
---|---|---|---|
1 | SA0014 : Avoid ‘fn_’ prefix when naming functions. | 1 | 20 |
