Latest

6/recent/ticker-posts

Header Ads Widget

Get Job Vacancy Notice, Download Syllabus and More Job Related.

Create Database In SQL Server

ADVERTISEMENT
ADVERTISEMENT

More Stuff


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 In SQL Server


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

ADVERTISEMENT
If You are going to Post a Comment, Please keep in mind that all comments are moderated and only comments that are relevant to the post topic will published. Let's have a meaningful conversation relevant to the post topic. THANK YOU. Check privacy policy HERE .

Post a Comment

0 Comments