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
‹
›
Home
View web version
No comments:
Post a Comment