How to retrieve field names from temporary table (SQL Server 2008) February 19, 2023 by Tarik select * from tempdb.sys.columns where object_id = object_id('tempdb..#mytemptable');