Click or drag to resize

SA0269 : Datatype identifier is not in the requried case

The topic describes the SA0269 analysis rule.

Message

Datatype identifier is not in the requried case

Description

The rule checks T-SQL code for datatype identifiers which do not use the required keyword case.

The parameter RequiredCase specifies the datatype identifier case.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters
NameDescriptionDefault Value
RequiredCase

The parameter specifies the required case of the reserved keywords.

lowercase

Remarks

The rule does not need Analysis Context or SQL Connection.

Categories

Naming Rules

Additional Information

There is no additional info for this rule.

Example Test Script
SQL
 1CREATE TABLE Test.Greeting
 2(
 3GreetingId [INT] identity (1,1) PRIMARY KEY,
 4Message [nvarchar](255) NOT NULL,
 5)
 6
 7CREATE TABLE Test.Greeting1
 8(
 9GreetingId int identity (1,1) PRIMARY KEY,
10Message nvarchar(255) NOT NULL,
11)
12
13CREATE TABLE Test.Greeting2
14(
15GreetingId Int identity (1,1) PRIMARY KEY,
16Message nvarChar(255) NOT NULL,
17)
18
19CREATE TABLE Test.Greeting1
20(
21GreetingId INT identity (1,1) PRIMARY KEY,
22Message NVARCHAR(255) NOT NULL,
23)

Analysis Results

 MessageLineColumn
1SA0269 : Datatype identifier is not in the requried case.311
2SA0269 : Datatype identifier is not in the requried case.1511
3SA0269 : Datatype identifier is not in the requried case.168
4SA0269 : Datatype identifier is not in the requried case.2111
5SA0269 : Datatype identifier is not in the requried case.228
See Also

Other Resources