title: Stored procedure that creates #table - unable to find it in list of tables
body: <p>I'm trying to run a stored procedure that creates a local table - #table1</p>
  
  <p>The stored procedure is supposed to look for values and create the table and insert the values into it...</p>
  
  <pre><code>INSERT INTO #table1
  </code></pre>
  
  <p>I execute the stored procedure and it shows that 1 row() affected, however, I am unable to find this table in the list of my tables. Why am I not able to see it or access it?</p>
  
  <p>EDIT: I'm running the stored procedure inside SQL Server against a database. At the end of the stored procedure, the last line is:</p>
  
  <pre><code>Select * from #table1 
  </code></pre>
  
  <p>Thanks.</p>