title: How to drop all tables from a database in sql server 2005 in a statement except one table
body: <p>I am using sql-server 2005. Initially, for learning purpose I created many tables now I want to drop all those tables except one which is currently I am working on. 
  Is there any code or query with which I can drop all tables from my that database except that one useful table.
  One way I think is to copy that table into new database using <code>SELECT INTO...</code> clause and drop that database but don't know is this a good way to solve this problem.</p>