Dropping and recreating databases in Microsoft SQL Server

USE master
IF EXISTS(select * from sys.databases where name="yourDBname")
DROP DATABASE yourDBname

CREATE DATABASE yourDBname