drop temp tables

If you have Global temp table ##temp, you can SELECT, INSERT and DROP it from other sessions.

But if it is Local temp table #temp and you wanted to delete it, you can write DROP TABLE #temp in that session itself.

---

-Vaibhav Chaudhari