SQL CREATE DATABASE Statement

SQL > SQL Administration > SQL CREATE DATABASE Statement

What is the SQL CREATE DATABASE Statement?

The SQL CREATE DATABASE statement is the SQL command that adds a new database. A database is the outer container for other SQL objects: tables, columns, views, indexes, etc.

Why Use the SQL CREATE DATABASE Statement?

Anytime you want to start a new database. For example, you may want to start a new project to integrate customer information and so create a database called CUSTOMER_DB.

How To Use the SQL CREATE DATABASE Statement

The SQL CREATE DATABASE statement is used as follows.

SQL CREATE DATABASE Statement Syntax

CREATE DATABASE <database_name>

SQL CREATE DATABASE Statement Example

The following example creates a new database named CUSTOMER_DB.

CREATE DATABASE customer_db