Home / Software / Tips and Tricks / where is the Temp tables located in SQL server database?

where is the Temp tables located in SQL server database?

Updated:  07/14/2014 11:07 AM
Author:  Shiju Mathews

Status:    Resolved.


  • Go to SSMS and connect to your server.
  • Expand Datatbases
  • Expand System Databases
  • Expand 'tempdb'
  • Expand 'Temporary Tables'
    Locate the table that you are searching.
  •