How to see temp table created by code in sql server?

InTheSkies picture InTheSkies · Jan 29, 2014 · Viewed 29k times · Source

I create a global temp table (i.e ##TheTable) using C# code. I want to be able to see that temp table in SQL server management studio after the code runs completely.

Is it possible to do this ? If yes, then how ?

Answer

TTeeple picture TTeeple · Jan 29, 2014

All temp tables are logged under SQL server > Databases > System Databases > tempdb -> Temporary Tables