DEP022
Published 20 November 2017
DROP INDEX with two-part name is deprecated
This syntax will be removed in a future version of Microsoft SQL Server. Avoid using this syntax in new development work, and plan to modify applications that currently use the feature.