Sql Query to find Temp tables in DB

Question

Please suggest me a query to find temp database tables.

Maybe this helps

Rob
– Rob

2010-09-15 14:12:37 +00:00
Commented Sep 15, 2010 at 14:12 — Rob
– Rob, Commented Sep 15, 2010 at 14:12

Martin Smith · Accepted Answer · 2010-09-15 14:15:34Z

13

select name from tempdb.sys.tables

answered Sep 15, 2010 at 14:15

Martin Smith

457k97 gold badges777 silver badges886 bronze badges

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

Comments

Sachin Shanbhag · Accepted Answer · 2010-09-15 14:16:03Z

7

All temp tables created are stored in the tempdb available on sql server. So run this query in tempdb, you will find available temp tables on the server -

select * from sysobjects where "xtype" = 'u'

Hope this will help you

answered Sep 15, 2010 at 14:16

Sachin Shanbhag

55.7k11 gold badges92 silver badges103 bronze badges

1 Comment

Simhadri Over a year ago

It also works good but Martin's solution is better I feel.Thanks for your time.

Collectives™ on Stack Overflow

Sql Query to find Temp tables in DB

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