title: SQL DROP TABLE foreign key constraint
body: <p>If I want to delete all the tables in my database like this, will it take care of the foreign key constraint? If not, how do I take care of that first?</p>
  
  <pre><code>GO
  IF OBJECT_ID('dbo.[Course]','U') IS NOT NULL
      DROP TABLE dbo.[Course]
  GO
  IF OBJECT_ID('dbo.[Student]','U') IS NOT NULL
      DROP TABLE dbo.[Student]
  </code></pre>