CREATE DATABASE

Creates a new database.

Syntax

CREATE DATABASE [IF NOT EXISTS] <database_name>
[ WITH 
[ DESCRIPTION = <description> ]
]

Parameters

Parameter Description
<database_name> The name of the database.
DESCRIPTION = 'description' The engine’s description (up to 64 characters).

Example

The following example creates a database with non-default properties:

CREATE DATABASE IF NOT EXISTS my_db
WITH DESCRIPTION = 'Being used for testing'