DROP TABLE IF EXISTS dbo.MyTable flagged as invalid

• 
  Hi Steve
  
  You’re correct but unfortunately the formatting system in v7.2 doesn’t fully support SQL Server 2016 syntax.
  
  The upcoming v7.3 beta’s formatting system will support this syntax but since IF EXISTS is quite simple I’ll look into adding support for it in v7.2 now.
  
  Thanks
  Ali

  Ali D June 01, 2016 05:52

  - 0 +
• 
  Thanks for the prompt response

  steveculshaw June 01, 2016 08:32

  - 0 +
• 
  Hi Steve
  
  I’ve had a look at supporting IF EXISTS in Prompt’s current formatting system. Unfortunately, because we’re in the middle of transitioning to a new and improved formatting system, backporting syntax support at this point is quite complex.
  
  This new formatting system supports IF EXISTS and will be released in the next Prompt beta. Sorry for the delay.
  
  Thanks
  Ali

  Ali D June 02, 2016 09:28

  - 0 +
• 
  Ali, this is still an issue and I am on 7.3. Any idea on when this will be fixed? Here is an example of what is still breaking. Thanks!
  
  CREATE TABLE #temp
  (
  test VARCHAR(20)
  )
  
  DROP TABLE IF EXISTS #temp

  hafnera January 19, 2017 17:09

  - 0 +
• 
  Hi hafnera
  
  I'm unable to reproduce the issue here. It might be that the new formatting feature isn't turned on. Please could you check that "SQL Prompt > Options > Labs > Experimental features > Use new formatting styles" is on?
  
  Many thanks
  Harry

  Harry Frankish January 20, 2017 03:51

  - 0 +
• 
  Harry,
  
  Enabling the new formatting styles resolved my issue. Thanks for the resolution!

  hafnera January 20, 2017 14:26

  - 0 +

Add comment

Please sign in to leave a comment.