SQL Server gets all column names for a temporary table or whether there are specified column names _mssql

Get all column names in a temporary table

select name from tempdb.dbo.syscolumns where id=object_id( '#TempTB')

To determine whether a specified column name exists in a temporary table

If Col_length (' tempdb.dbo. #TempTB ', ' columnName ')
  is not null print ' exists '
else
  print ' does not exist '

The above is the entire content of this article, I hope the content of this article for everyone's study or work can bring some help, but also hope that a lot of support cloud Habitat community!