EX0004 : Find identifier references inside the T-SQL script |
 |
The rule scans T-SQL code for references to a specific identifier, as defined by the rule parameters. The rule can be used as a base rule for creating variants that identify references to particular identifiers in code.
DescriptionFor example, the following query references the Sales table, which matches the IdentifierName rule parameter:
SQL
1SELECT * FROM Sales WHERE SalesDate = @StartDate;
This query will trigger a rule violation.
ScopeThe rule has a Batch scope and is applied only on the SQL script.
Parameters| Name | Description | Default Value |
|---|---|---|
| IdentifierName |
Identifier name. The parameter is required. |
|
| CaseSensitive |
Specifies if the identifier name is case sensitive. |
no |
RemarksThe rule does not need Analysis Context or SQL Connection.
Effort To FixNot configured.
CategoriesExplicit Rules
Additional InformationThere is no additional info for this rule.
Example Test SQL|
SQL
|
Analysis ResultsNo violations found.
See Also