Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Find Unused Variables and Parameters DROP IF EXISTS

woj123woj123 Posts: 7 Bronze 2
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

  • James RJames R Posts: 104 Silver 4
    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.