SQL Keyword CREATE DATABASE

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

  • In order to create a database, the user must have admin privileges.

The below SQL statement creates a new database.

Run this on IDE

CREATE DATABASE test_db;

After creating a database, we can use the below SQL to list all the available databases.

SHOW DATABASES;

Related Links