Create Database In SQL Server

ADVERTISEMENT

---

Creating Database In Sql Server is the first step of the database learn here i am given the sample example

CREATE DATABASE [tutorialsdb]

This is the simple example of creating database this directly create the database with following proprieties

CREATE DATABASE [tutorialsdb]
 CONTAINMENT = NONE
 ON  PRIMARY
( NAME = N'tutorialsdb', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\tutorialsdb.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON
( NAME = N'tutorialsdb_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\tutorialsdb_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

You can change the database name and other information as per you database requirement