where is the Temp tables located in SQL server database?

Validating the user

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: December 2025