Find Unused Variables and Parameters DROP IF EXISTS

woj123woj123 Posts: 7 Bronze 1
edited March 3, 2017 5:05AM in SQL Prompt
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.

Comments

  • 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
    Software Engineer
    Redgate Software
Sign In or Register to comment.