SA0073B : Check all User-Defined Types for following specified naming convention
The topic describes the SA0073B analysis rule.
Check all User-Defined Types for following specified naming convention
The rule checks the type name in CREATE TYPE statements.
The NamePattern variable can be used to select or configure the desired pattern which will be used to check the object name.
Regular expression patterns can be used, but the pattern must be prefixed with ‘regexp:’ string in order to be used as a matching regular expression.
Review the object name and rename it according to the naming convention.
The rule has a Batch scope and is applied only on the SQL script.
Deault constraint name pattern.
The rule does not need Analysis Context or SQL Connection.
Naming Rules, Code Smells
There is no additional info for this rule.
1CREATE TYPE SSN 2FROM varchar(11) NOT NULL ; 3 4CREATE TYPE Utf8String 5EXTERNAL NAME utf8string.[Microsoft.Samples.SqlServer.utf8string] ; 6 7CREATE TYPE LocationTableType AS TABLE 8 ( LocationName VARCHAR(50) 9 , CostRate INT );
|1||SA0073B : The user defined type name Utf8String does not match the naming convention. The expected name is [[A-Z][A-Za-z]+].||4||12|