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