SQL CREATE DATABASE Statement
The CREATE DATABASE statement is used to create a database.SQL CREATE DATABASE Syntax
CREATE DATABASE dbname;
Ex:
The following SQL statement creates a database called "SQLDBAGeneration":
There are different types to create a database in sql server
Ex:
The following SQL statement creates a database called "SQLDBAGeneration":
There are different types to create a database in sql server
Ex:
CREATE DATABASE SQLDBAGeneration ;
or
CREATE DATABASE [SQLDBAGeneration] ON PRIMARY
( NAME = N'SQLDBAGeneration', FILENAME = N'F:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\SQLDBAGeneration1.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'SQLDBAGeneration_log', FILENAME = N'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\SQLDBAGeneration_log1.ldf' , SIZE = 103424KB , MAXSIZE = 2048GB , FILEGROWTH = 102400KB )
GO
or
Right click on sql instance then click new database and provide the database name which you want create on sql .
