title: How do I delete all tables in a database using SqlCommand?
body: <p>Unlike the other posts about the task "delete all tables", this question is specifically about using <code>SqlCommand</code> to access the database.</p>
  
  <p>A coworker is facing the problem that no matter how it attempts it, he can't delete all tables from a database via SqlCommand. He states that he can't perform such action as long as there is an active connection - the connection by the SqlCommand itself.</p>
  
  <p>I believe this should be possible and easy, but I don't have much of a clue about databases so I came here to ask. It would be awesome if you could provide a short code example in C# (or any .NET language, for that matter).</p>
  
  <p>If you require additional information, just leave a comment.</p>