Create a Database in SQL Server

-- drop database if already exists:
if exists (select * from master..sysdatabases where name = N'DatabaseName')
    begin
        drop database [DatabaseName];
    end;
go

-- create database:
create database [DatabaseName];
go