How to create database in Microsoft SQL Server using SQL Statement

Here we will create database named Futzen in Microsoft SQL Server

Step1: Login into SQL Server using SQL Server Management Studio (SSMS) using required credentials

Step2: Use Master

go

--and press F5

Step3: CREATE DATABASE FUTZEN

ON PRIMARY

(NAME = N'futzen', FILENAME = N'c:\futzen.mdf' , SIZE = 1000KB , MAXSIZE = UNLIMITED)

LOG ON

( NAME = N'futzen_log', FILENAME = N'c:\futzen_log.ldf' , SIZE = 1000KB , MAXSIZE = 100GB)

WITH CATALOG_COLLATION = DATABASE_DEFAULT

and press F5 to create database

replace futzen with your database name