Click or drag to resize

SA0196 : Deprecated use of DROP INDEX with two-part index name syntax

The topic describes the SA0196 analysis rule.

Message

Deprecated use of DROP INDEX with two-part index name syntax

Description

The rule checks DROP INDEX statements for using the backward compatible syntax with two-part index name.

The backward compatible syntax is deprecated and it is recommended to replace it with index_name ON table_name syntax.

Scope

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

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Categories

Design Rules, New Rules

Additional Information

There is no additional info for this rule.

Example Test Script
1DROP INDEX Test.Greeting.IX_Greeting_GreetingId  
2
3DROP INDEX IX_Greeting_GreetingId ON Test.Greeting,  IX_Greeting_GreetingId ON Test.Greeting

Analysis Results

 MessageLineColumn
1SA0196 : Deprecated use of DROP INDEX with two-part index name syntax.20
See Also

Other Resources