CREATE DATABASE

CREATE DATABASE creates a new database in SQream.

Permissions

Only a superuser can create a new database

Syntax

create_database_statement ::=

    CREATE DATABASE database_name ;

database_name ::= identifier

Parameters

Parameter

Description

database_name

The name of the database name. The database name must be unique, and follows Identifier rules

Examples

CREATE DATABASE raviga;
CREATE DATABASE my_db;

If the database already exists, an error will appear:

master=> CREATE DATABASE MY_DB;
Database 'my_db' already exists

Note

SQream DB identifiers are always converted to lowercase, so my_db is the same as MY_DB, unless explicitly quoted as "MY_DB".