SQL Create Database

A database is a key thing which is required before doing any operation with the data like, INSERT, SELECT, UPDATE etc. All the database systems provide us different ways to create a database. It can be done using GUI, SQL query editor etc.

The SQL statement CREATE DATABASE is supported by almost all the databases to create a database

Syntax

Following is the syntax to create a database in SQL

CREATE DATABASE < database_name > 

CREATE DATABASE Example

The following SQL statement creates a database named SampleDB

CREATE DATABASE SampleDB


USE Statement

In most of the database systems, after creating the database they do use the database directly. To make use of the Database the USE keyword is used.

following is the syntax to USE a database.

USE <database_name>

Example

USE SampleDB