How to create database in SQL Server: 1. Using Sql Server Management Studio 2. Using T-SQL Script 1. Using SQL Server Management Studio ![]() 2. Using T-SQL Script: USE [master] GO /****** Object: Database [Sales] ******/ CREATE DATABASE [Sales] CONTAINMENT = NONE ON PRIMARY ( NAME = N'Sales', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER01\MSSQL\DATA\Sales.mdf' , SIZE = 2048KB , MAXSIZE =UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'SalesOrders_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER01\MSSQL\DATA\Sales.ldf' , SIZE = 1024KB , MAXSIZE =2048MB , FILEGROWTH = 10%) GO |