Sql Query to find Temp tables in DB

Please suggest me a query to find temp database table开发者_运维知识库s.

---

select name from tempdb.sys.tables

---

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