title: Get structure of temp table (like generate sql script) and clear temp table for current instance
body: <p>How do I get structure of temp table then delete temp table.  Is there a sp_helptext for temp tables?  Finally is it possible to then delete temp table in same session or query window?<br /><br />
  Example:</p>
  
  <pre><code>select *
  into #myTempTable  -- creates a new temp table
  from tMyTable  -- some table in your database
  
  tempdb..sp_help #myTempTable
  </code></pre>
  
  <p><a href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72960" rel="noreferrer">Reference</a>.</p>