EX0021 : Check DROP TABLE statements in order to avoid unintentional data loss |
 |
The topic describes the EX0021 analysis rule.
MessageCheck DROP TABLE statements in order to avoid unintentional data loss
DescriptionThe rule examines T-SQL code and reports all DROP TABLE statements, which are not ignored using a rule suppression comment.
ScopeThe rule has a Batch scope and is applied only on the SQL script.
ParametersRule has no parameters.
RemarksThe rule does not need Analysis Context or SQL Connection.
CategoriesExplicit Rules
Additional InformationThere is no additional info for this rule.
Example Test ScriptSQL
1DROP TABLE Test.Greeting 2 3DROP TABLE Test.Greeting -- IGNORE:EX0021 4 5DROP TABLE #temp, aaa
Analysis Results
| Message | Line | Column | |
|---|---|---|---|
| 1 | EX0021 : Check DROP TABLE statements in order to avoid unintentional data loss. | 1 | 0 |
| 2 | EX0021 : Check DROP TABLE statements in order to avoid unintentional data loss. | 5 | 0 |
See Also