Where are Temp tables found??? | SansSQL

Thursday, June 5, 2008

Where are Temp tables found???

Temp tables are found in the Tempdb database. we can find the names of the temp tables that are created by executing the below Query

Select * from tempdb..sysobjects where type = 'U'

No comments:

Post a Comment

Ads