title: Are indexes on temporary tables deleted when the table is deleted?
body: <p>Would the following SQL remove also the index - or does it have to be removed separately?</p>
  
  <pre><code>CREATE TABLE #Tbl (field int)
  
  CREATE NONCLUSTERED INDEX idx ON #Tbl (field)
  
  DROP TABLE #Tbl
  </code></pre>