title: Dropping and recreating databases in Microsoft SQL Server
body: <p>I am experimenting and learning with Microsoft SQL Server 2008 R2 SP1.
  I have a database where I made many experiments. Now I would like to drop and recreate it.
  So I extract the creation script from database, I delete it and I use the script to recreate it.
  To my surprise, all the tables, keys etc are still there.
  How do I drop the database, so that I can rebuild the database from scratch?</p>