SQL CREATE DATABASE Statement — SQL interactive lesson

The SQL CREATE DATABASE Statement

The CREATE DATABASE statement is used to create a new SQL database.

Tip

You need administrative privileges to create a new database.

Syntax

CREATE DATABASE
database_name
;

The following SQL statement creates a database called "testDB":

Example

CREATE DATABASE testDB;

Once a database is created, you can check it in the list of databases with the following SQL command:

SELECT name FROM sys.databases;

SHOW DATABASES;