How can we help you today? How can we help you today?

Find Unused Variables and Parameters DROP IF EXISTS

Using SQL Prompt version 7.5.0.675 I "Find Unused Variables and Parameters" but get "SQL Prompt was unable to complete this operation. Problem areas have been highlighted." This is the statement it fails on:

DROP TABLE IF EXISTS #temp

However, the statement can be "Format SQL"-formatted without error.
woj123
0

Comments

1 comment

Sort by
  • James R
    Hi woj123,

    Thanks for reporting this issue. It seems to be a problem with the SQL Server 2016 DROP IF EXISTS syntax.

    I've logged this in our system and one of the team will look into it soon :).

    Regards,
    James
    James R
    0

Add comment

Please sign in to leave a comment.