How to find/see tempdb in SQL Server

Question

Should I expect to be able to see tempdb tables in SSMS?

e.g. If I run this code, should I expect to be able to see the table in SSMS?

-- Drop the table if it already exists    
IF (SELECT OBJECT_ID('tempdb..#TempPasswords')) IS NOT NULL
    DROP TABLE #TempPasswords

CREATE TABLE #TempPasswords (
    MemberNo    INT,
    Password    nvarchar(120),
    NewPassword varbinary(MAX)
)

user11380812 · Accepted Answer · 2019-07-16 07:16:14Z

2

Only if you run your code snippet in SSMS. In that session you will be able to execute

T-SQL that include your temp table.

In order to see temp tables globally use two hashes ##.

answered Jul 16, 2019 at 7:16

user11380812

Sign up to request clarification or add additional context in comments.

Comments

Khairul Alam · Accepted Answer · 2019-07-16 08:31:57Z

1

It is possible to see the temp DB but the name only. To see temp DB follow the instruction as per the image. After running the query right click on the Temporary Tables and Refresh .

edited Jul 16, 2019 at 8:31

answered Jul 16, 2019 at 8:24

Khairul Alam

1,3462 gold badges13 silver badges33 bronze badges

1 Comment

Allan F Over a year ago

I noted that actions that are normally available with tables are not available within SSMS with temp tables .. via SSMS menus .. e.g. "Select Top 1000 Rows" ..

Collectives™ on Stack Overflow

How to find/see tempdb in SQL Server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related