SQL Server Database Creation database

CREATE database name
On [PRIMARY]
(
< data file parameters > [, ... n] [< file group parameters;]
)
[LOG on]
(
< log file parameters > [, ... n]
)

Source:
CREATE DATABASE MySchool
On PRIMARY--The default is the PRIMARY primary filegroup, which can be omitted
(
Name= ' Myschool_data ',--the logical name of the master data file
Filename= ' D:\project\MySchool_data.mdf ',--the physical name of the master data file
SIZE=5MB,--Primary data file Initial size
MAXSIZE=100MB,--Maximum value of master data file growth
filegrowth=15%--Growth rate of master data files
)
LOG on
(
Name= ' Myschool_log ',
Filename= ' D:\project\MySchool_log.ldf ',
SIZE=2MB,
Filegrowth=1mb
)
GO

SQL Server Database Creation database