You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “Drop Temp Table If Exists”.
You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “Drop Temp Table If Exists”.
derek,
thanks for the script. knew how to drop user tables, but wasn’t sure about the temp location.
jeff
how can be drop ##temp table without using database name .
Hi Kyaw,
In this case, you do need the database name of TempDB because that is always where temporary tables are stored.
Derek