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
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
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.