When working with Temp tables I often face issues in case a script contained an error and the execution was stopped in the middle.

First run will create a temporary table but due to an error in one of the statements the script will not complete, so the final statement with DROP TABLE is not executed.

Next, when running the script again I get the error that table exists in DataSet which is true - it is trying to create the same table again, so the error message is correct.

In order to reset the state I try to run only the line with only the DROP TABLE statement and get the error:

Msg 40000, Level 16, State 1, Line 212
{"Message":"'DROP TABLE' statement​ is not supported. Line:1, Position:1"}