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.
  • Tags: where is the Temp tables located in SQL server database?
    Updated on: April 2024