Column exists in temp table

Is there a way I can test to see if a certain column exists in a temporary table?
LVL 6
PsychoDazeyAsked:
Who is Participating?
 
obahatCommented:
SELECT * FROM tempdb..syscolumns where id = object_id('tempdb..#<TempTableName>')
0
 
PsychoDazeyAuthor Commented:
thank you sir!  I should have known to look in TempDB....DOH!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.