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