title: Finding #temp table in sysobjects / INFORMATION_SCHEMA
body: <p>I am running a <code>SELECT INTO</code> statement like this so I can manipulate the data before finally dropping the table.</p>
  
  <pre><code>SELECT colA, colB, colC INTO #preop FROM tblRANDOM
  </code></pre>
  
  <p>However when I run the statement and then, without dropping the newly created table, I then run either of the following statements, the table isn't found? Even scanning through object explorer I can't see it. Where should I be looking?</p>
  
  <pre><code>SELECT [name] FROM sysobjects WHERE [name] = N'#preop'
  SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '#preop'
  </code></pre>