Get Temporary Table Column Names in SQL Server

When a temporary table is created, a record gets created in tempdb’s sys.tables and tempdb.sys.columns system table. You can query these tables to get meta data information from a temporary table.

Here’s how to retrieve a Temporary Table’s Column Names. Let’s first create a temporary table with some columns

create table #SomeTmpTbl
(
col1 int,
col2 varchar(20),
col3 datetime
)

Now query the tempdb.sys.columns in the following manner

select * from tempdb.sys.columns where object_id =
object_id('tempdb..#SomeTmpTbl');

and there you go!