create
table
#SomeTmpTbl
(
col1
int
,
col2
varchar
(20),
col3 datetime
)
GO
select
*
from
tempdb.sys.columns
where
object_id =
object_id(
'tempdb..#SomeTmpTbl'
);