Where are temp tables in SQL Server

Question

In SAS, temp tables stored in WORK, which locates at the bottom of library list.

In SQL Server, create a temp table like #t1 in tempdb. But in the databases list, I cannot find the tempdb.

The reason why I want to "see" it is I want to know its variables' data type and other related information.

It might depend on version, but in SQL 2012 you'll find the tempdb under System Databases and the #t1 would be under Temporary Tables I don't think you can see the structure of the table there though. — jpw
– jpw, Commented Oct 24, 2014 at 2:29
Yea I find it. But as you said, nothing useful information was found there. — Lovnlust
– Lovnlust, Commented Oct 24, 2014 at 2:41

TeamTam · Accepted Answer · 2014-10-24 02:31:11Z

5

tempdb

You have to expand 'System Databases' to see it.

answered Oct 24, 2014 at 2:31

TeamTam

1,60812 silver badges15 bronze badges

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

Comments

Circadian · Accepted Answer · 2014-10-24 02:31:33Z

0

You can try running the following:

 exec sp_columns YourTempTableName.

That should give you your columns and types.

answered Oct 24, 2014 at 2:31

Circadian

5794 silver badges4 bronze badges

Comments

Grantly · Accepted Answer · 2014-10-24 02:31:40Z

0

You may not have security access to that database. Are you sys admin? Or using Sa credentials? There Are four system databases, model, master, tempdb and msdb ... Can you see any of these? If not, you need SQL permission set for your login

answered Oct 24, 2014 at 2:31

Grantly

2,5642 gold badges23 silver badges32 bronze badges

Collectives™ on Stack Overflow

Where are temp tables in SQL Server

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related