SQL CREATE DB

The SQL CREATE DATABASE Statement

The CREATE DATABASE statement is employed for initiating a fresh SQL database.

Syntax

CREATE DATABASE databasename;

CREATE DATABASE Example

This SQL statement establishes a database named “testDB”.

Example

CREATE DATABASE testDB;

Tip: Ensure you possess administrative privileges prior to initiating any database creation. After creating a database, its presence can be confirmed within the list of databases using the SQL command: SHOW DATABASES;