bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch
Learn/SQL/SQL Database
SQL•SQL Database

SQL CREATE DATABASE Statement

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

;

CREATE DATABASE Example

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

Example

CREATE DATABASE testDB;

Show Databases

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

Syntax for SQL Server

SELECT name FROM sys.databases;

Syntax for MySQL

SHOW DATABASES;

Next

SQL DROP DATABASE Statement