title: How come the message "Table is marked for deletion" keeps appearing?
body: <p>Using SQL Server 2008 and I'm doing some schema construction in the Management Studio designer.</p>
  
  <p>I created a table early in the process called "Animal", but then decided to delete shortly after. I deleted it via the tree view in Management Studio (right-click delete).</p>
  
  <p>Now I'm late in the process, I would like to recreate the table "Animal" but with different fields.</p>
  
  <p>The second time round with Animal gets created fine, but when I try to add the table to my diagram I get the message "Table 'Animal' is marked for deletion, can't be added to the diagram or opened in the table designer".</p>
  
  <p>What's the deal? How can I use this table normally again and not suffer from older table naming conflicts?</p>
  
  <p>Alternatively, if the table is marked for deletion, can I actually invoke deletion somehow? Then recreate another table with the same name.</p>
  
  <p>This is a little annoying. Would appreciate any help.</p>