Info, Tutorials, Downloads, Audio Books, Videos, Ebooks and More

Tuesday, July 11, 2017

Create Database In SQL Server

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

Recommended Articles :


No comments:

Post a Comment

Dear Readers,

Great !! You've decided to leave comment for us. Let's make meaningful conversation by adding your name.

Please note that,

Comments deemed to be spam or questionable spam, including profanity and containing language or concepts that could be deemed offensive will be deleted.
Including a link to relevant content is permitted, but comments should be relevant to the post topic.