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 [tutorialsdb]You can change the database name and other information as per you database requirement
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
0 Comments