T-SQL Analyzer

# SQL Server Rule: SRN0007 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Performance | | Class | GeneralNamingRules | ## Rule Information | | | |----|----| | Id | SRN0007 | | Friendly Name | Name standard | | Category | Naming | | Ignorable | false | | Applicable Types | Check Constraint | | | Default Constraint | | | Dml Trigger | | | Foreign Key Constraint | | | Index | | | Primary Key Constraint | | | Procedure | | | Scalar Function | | | Table | | | Table Valued Function | | | View | ## Description General naming rules. ## Summary General naming violation. ### Examples ```sql Create Table dbo.SomeText ( ID integer primary key, [SomeText] TEXT NULL ) -- SML047, SRD0051, SRN0007 ``` ### Remarks Multiple possible rule violations: <list type="bullet"> <item> Name '{name}' starts with a number. </item> <item> Name '{name}' contains invalid characters. Please only use alphanumerics and underscores. </item> <item> Primary Key '{name}' does not follow the company naming standard. Please use the name PK_{tableName}. </item> <item> Index '{name}' does not follow the company naming standard. Please use the name IX##_{tableName}. </item> <item> Foreign Key '{name}' does not follow the company naming standard. Please use the format FK##_{tableName}. </item> <item> Check Constraint '{name}' does not follow the company naming standard. Please use the format CK_*. </item> <item> Constraint '{name}' does not follow the company naming standard. Please use the name DF_{tableName}_{columnName}. </item> </list> _{^{Generated by a tool}}