SA0074B : Check all Schema-s for following specified naming convention
The topic describes the SA0074B analysis rule.
Check all Schema-s for following specified naming convention
The rule checks the schema name in CREATE SCHEMA 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 SCHEMA Sprockets AUTHORIZATION Annik 2 CREATE TABLE NineProngs (source int, cost int, partnumber int) 3 GRANT SELECT ON SCHEMA::Sprockets TO Mandar 4 DENY SELECT ON SCHEMA::Sprockets TO Prasanna; 5 6ALTER SCHEMA Sprockets TRANSFER Person.Address;
No violations found.