your image

SQL Create Database

quackit
Related Topic
:- SQL

You can create a database using the CREATE DATABASE command.

SQL syntax

 

CREATE DATABASE database_name;

Example Code

This statement creates a database called Payroll. Because no arguments have been specified, the database data files and transaction logs will be created automatically in the default location.

 

 
CREATE DATABASE Payroll;

Adding Arguments

There are a number of optional arguments that you can supply with the CREATE DATABASE command. You should check your database system's documentation for the specific arguments supported and their usage, but here's an example of supplying arguments when creating a database using Microsoft's SQL Server.

Example Code

In this example, we are supplying the name and location of the database's data file and transaction log. We are also specifying the initial size of these files (with the SIZE argument), the maximum size it can grow to (with the MAXSIZE argument) and the growth increment of each file (using the FILEGROWTH) argument.

 

 
USE master
GO
CREATE DATABASE Payroll
ON
( NAME = Payroll_dat,
  FILENAME = 'c:\program files\microsoft sql server\mssql\data\payrolldat.mdf',
  SIZE = 20MB,
  MAXSIZE = 70MB,
  FILEGROWTH = 5MB )
LOG ON
( NAME = 'Payroll_log',
  FILENAME = 'c:\program files\microsoft sql server\mssql\data\payroll.ldf',
  SIZE = 10MB,
  MAXSIZE = 40MB,
  FILEGROWTH = 5MB );
GO

Note that in SQL Server the GO keyword is used to indicate the end of a batch. This keyword is not necessary in MySQL and other database management systems.

Comments