title: Is there a way to expand the column list in a SELECT * from #Temp_Table in SSMS?
body: <p>As seen here <a href="http://dattatreysindol.com/2012/06/07/tips-n-tricks-ssms-view-the-column-list-data-types-and-null-option-in-query-tooltips/" rel="noreferrer">LINK</a> you can hover over the <code>*</code> in a <code>SELECT * from...</code> and a tooltip will come up with a list of the columns represented by that <code>*</code>.</p>
  
  <p>Is there a way to copy the text from the tooltip to the clipboard?</p>
  
  <p>I know that you can use the columns folder in the object explorer to generate a list of columns by dragging it into the query editor window, but this cannot work for temp tables as they do not appear in the object explorer.</p>
  
  <p>EDIT</p>
  
  <p>For completeness sake, the answer below "You can right-click on the table in Object Explorer and select Script Table as->CREATE to->New Query Editor Window." is also not workable for the same reason as above.</p>
  
  <p>END EDIT</p>
  
  <p>I do not see a way to do this in SSMSBoost, which is an add-on for SSMS that I use. (The only reason I mention it is I am pretty sure I have seen the SSMSBoost developers on SO, feature request??)</p>
  
  <p>EDIT 2: 
  Is there any other way to quickly expand the <code>*</code> in a <code>SELECT * from #Temp_Table</code> without actually running the code to create the temp table?
  END EDIT 2</p>