task_005_create_database

Create Database

learn.microsoft.com » sql » relational-databases » databases » create-a-database

• Create a new database Sales

USE master;
GO
CREATE DATABASE Sales

• Create database if NOT EXISTS stackoverflow : Create database if db does not exist

USE master
GO

IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = 'MyTestDataBase')
BEGIN
  CREATE DATABASE MyTestDataBase;
END;
GO