CREATE DATABASE

Reference and syntax for the CREATE DATABASE command.

Creates a new database.

Each account supports up to 100 databases. If you need more, contact Firebolt’s support team at [e-mail].

Syntax

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

Parameters

Parameter	Description
<database_name>	The name of the database.
DESCRIPTION = 'description'	(Optional) The database’s description, which can contain up to 64 characters.

Example

The following code example creates a database named my_db with an optional description, Testing database:

CREATE DATABASE IF NOT EXISTS my_db
WITH DESCRIPTION = 'Testing database'