title: How can I resolve the "Table 'dbo.Foo' already exists." error when the table does not exist?
body: <p>I've created a table and then realised I made a mistake. SSMS wouldn't let me update the table without recreating it, so I've deleted the table and then tried to create it again.</p>
  
  <p>It won't let me do this, and I get an error dialog</p>
  
  <blockquote>
    <p>Table 'dbo.Foo' already exists.</p>
  </blockquote>
  
  <p>So I try to delete it again:</p>
  
  <pre><code>drop table dbo.Foo
  </code></pre>
  
  <blockquote>
    <p>Cannot drop the table 'dbo.Foo', because it does not exist or you do not have permission.</p>
  </blockquote>
  
  <p>Refreshing the IntelliSense cache does not help.</p>