Create Database In SQL Server




Follow SANGITAB Blog With Bloglovin

To Get Regular Updates on Facebook

Like Our Facebook Page

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


Follow

More From Our Site:

No comments


About Us | HTML to XML Converter | Webmail Service | Nepali Unicode | Advertise | TC & Privacy Policy | Contact Us | DMCA.com Protection Status