SA0063B : Check view names used in CREATE VIEW statements for following specified naming convention
The topic describes the SA0063B analysis rule.
Check view names used in CREATE VIEW statements for following specified naming convention
The rule checks view names used in CREATE VIEW statements.
The NamePattern variable can be used to select or define 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 view name and rename it according to the naming convention.
The rule has a Batch scope and is applied only on the SQL script.
View name pattern.
Schema qualified 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 VIEW dbo.Customers 2AS 3--Select from local member table. 4SELECT * 5FROM CompanyData.dbo.Customers_33 6UNION ALL 7--Select from member table on Server2. 8SELECT * 9FROM Server2.CompanyData.dbo.Customers_66 10UNION ALL 11--Select from mmeber table on Server3. 12SELECT * 13FROM Server3.CompanyData.dbo.Customers_99
|1||SA0063B : The view [dbo].[Customers] does not match the naming convention. The expected key name is [v[A-Z][A-Za-z1-9_]+].||1||16|