title: Sql Server Management studio drop table and re-create issue
body: <p>I have created a table with primary key and foreign key using SQL Server Management studio 2008R2, then I have drop the table using the sql command drop table nameofthetable and the table has been dropped.
  After that I have created another table with the same name of the dropped table but I get this error: </p>
  
  <blockquote>
    <p>" The table 'name of my table' already exists'.</p>
  </blockquote>
  
  <p>Why? I don't see the old table in my table list.</p>
  
  <p>Can you help me, I need to create the table with this name?</p>