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.
CREATE DATABASE test_db;
After creating a database, we can use the below SQL to list all the available databases.
SHOW DATABASES;