Menu
Please suggest me a query to find temp database tables.
730
Now, to see where this table exists; go to “Object Explorer -> Databases -> System Databases-> tempdb -> Temporary Tables”. You will see your temporary table name along with the identifier.
. Once the temp table has been created, execute this statement within the same session (tab in SSMS). The output will have a row per line definition of the table, in column order, that can be used to explicitly declare the temp table.
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
24
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
