T-SQL Analyzer

# SQL Server Rule: SRN0001 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Naming | | Class | AvoidFNPrefixRule | ## Rule Information | | | |----|----| | Id | SRN0001 | | Friendly Name | UDF with System prefix | | Category | Naming | | Ignorable | true | | Applicable Types | Partition Function | | | Scalar Function | | | Table Valued Function | ## Description Avoid 'fn_' prefix when naming functions. ## Summary Function name may conflict system name. Avoid 'fn_' prefix when naming functions. ### Remarks 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. _{^{Generated by a tool}}