Drop all temp tables in current scope
Have a procedure with tons of temp tables you don’t want to keep track of? Or debugging some nasty code with tons of temp tables? This SQL snippet is quite handy. It will drop all the temp tables in your current scope. Enjoy!