MSSQL SERVER database creation script with specified size and growth

USE master
GO

CREATE DATABASE [Prod]
 CONTAINMENT = NONE
 ON  PRIMARY
( NAME = N'Prod',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\Prod.mdf' , --<< this must be in its own physical drive
SIZE = 5MB , --<< pre size the data file 5000 mb
FILEGROWTH = 1MB )  --<< pre size the log file 100 mb

 LOG ON
( NAME = N'Prod_log',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\Prod.ldf' , --<< this must be in its own physical drive
SIZE = 1MB , --<< pre size size of transaction log file 100 mb
FILEGROWTH = 1MB ) --<< pre size size auto growth to increase in increments of 5 mb
GO

MS SQL Server create database command by setting file growth size

--Create database command by setting file growth size  

CREATE DATABASE [fixed_size]

 CONTAINMENT = NONE

 ON  PRIMARY 

( NAME = N'auto_fixed_size', 

FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\auto_fixed_size.mdf' , 

SIZE = 1024000KB ,       --<< initial size of data file 1000mb 

FILEGROWTH = 102400KB )  

 LOG ON 

( NAME = N'auto_fixed_size', 

FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\auto_fixed_size.ldf' , 

SIZE = 102400KB , 

FILEGROWTH = 102400KB ) --<< growth by 100mb (PRE SIZED SO THAT THE AUTO GROWTH DOES NOT ACTIVATE)

GO

DBCC LogInfo

MS SQL Server Create database command with auto growth

Use master
go

CREATE DATABASE [auto_growth]
 CONTAINMENT = NONE
 ON  PRIMARY
( NAME = N'auto_growth',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\auto_growth.mdf' ,
SIZE = 3072KB ,      --<< initial size of data file 3mb     
FILEGROWTH = 1024KB )  --<< growth by 1mg

 LOG ON
( NAME = N'auto_log',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\auto_growth_log.ldf' ,
SIZE = 1024KB ,    --<< initial size of log file 1mb
FILEGROWTH = 10%)  --<< growth by 10%
GO

DBCC LogInfo;