Where does temporary tables gets stored in database. I want to drop a temporary table if it already exists. I can do this for securable table by querying at information schema but i done know where temporary tables are stored
+4
A:
Temporary tables are stored in tempdb Database. There are various ways to check if a temp table exists outlined here: Check If Temporary Table Exists.
Giorgi
2010-06-10 08:09:36