SQL Server not showing column specs

Question

Using the command

sp_columns 'DimDiagnosis' 

gives me the column names and column specs for an existing table dimDiagnosis.

But when I try the same syntax for a temp table that I am producing,

sp_columns '#Diagnosis' 

gives me only column names; I am not getting column specs. What is the solution?

question from:https://stackoverflow.com/questions/65927321/sql-server-not-showing-column-specs

Answer 1

Temp tables reside in the tempdb. You should be able to use either:

use tempdb; exec sp_columns '#Diagnosis'

or:

exec tempdb..sp_columns '#Diagnosis'