Where are Temp tables found??? | SansSQL
Top Menu
Home
Disclaimer
Contact Us
Downloads
Blog
Database
MSSQL
BI & Analytics
MSBI
Big Data
MongoDB
Cloud Computing
AWS
Cyber Security
Search SansSQL
Apps
Find SQL Server Build Name
SQL Server Max Memory Recommendation Calculator
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Ads
No comments:
Post a Comment