SQL Server Error Msg 8391 – The usage of 2-part names in DROP INDEX is deprecated. New-style syntax DROP INDEX <1p-name> ON {<3p-table-name> | <3p-view-name> }

In this blog post, let’s learn about the error message “8391 – The usage of 2-part names in DROP INDEX is deprecated. New-style syntax DROP INDEX <1p-name> ON {<3p-table-name> | <3p-view-name> }” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

8391 – The usage of 2-part names in DROP INDEX is deprecated. New-style syntax DROP INDEX <1p-name> ON {<3p-table-name> | <3p-view-name> }

Reason for the Error

To be update soon…

Solution

To be update soon…