title: Could not drop object 'dbo.Table1' because it is referenced by a FOREIGN KEY constraint
body: <p>Even though I am removing and trying to drop table, I get error,</p>
  
  <pre><code>ALTER TABLE [dbo].[Table1] DROP CONSTRAINT [FK_Table1_Table2]
  GO
  
  DROP TABLE [dbo].[Table1]
  GO
  </code></pre>
  
  <p>Error</p>
  
  <blockquote>
    <p>Msg 3726, Level 16, State 1, Line 2 Could not drop object 'dbo.Table1'
    because it is referenced by a FOREIGN KEY constraint.</p>
  </blockquote>
  
  <p>Using SQL Server 2012</p>
  
  <p><strong>I generated the script using sql server 2012, so did sQL server gave me wrong script ?</strong></p>