IF EXISTS (SELECT *
FROM master..sysdatabases
WHERE name = N'<database_name, sysname, test_db>')
DROP DATABASE <database_name, sysname, test_db>
GOCREATE DATABASE <database_name, sysname, test_db>
GO
FROM master..sysdatabases
WHERE name = N'<database_name, sysname, test_db>')
DROP DATABASE <database_name, sysname, test_db>
GOCREATE DATABASE <database_name, sysname, test_db>
GO
if not exists(SELECT *
FROM master..sysdatabases
WHERE name = N'TradeDB')
CREATE DATABASE TradeDB