SQL CREATE DATABASE


David Haertzen David Haertzen, Tutorial Author
Check out our
Data Warehousing Tutorial.
Previous | Next

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
 

Copyright© 1999-2015, First Place Software, Inc.