DF196: The DROP INDEX with two-part index name is used.

The topic describes the DF196 T-SQL code analysis rule.

Category

DEPRECATED

Message

The DROP INDEX with two-part index name is used.

Description

It is not recommended to use this syntax as it is deprecated and will be removed in a future version of Microsoft SQL Server. Instead, use DROP INDEX < name > ON < table_name >.

Noncompliant code example

DROP INDEX dbo.DemoTable.MyIndex;
GO

Compliant solution

DROP INDEX MyIndex ON dbo.DemoTable;
GO