CREATE DATABASE¶

CREATE DATABASE creates a new database in BLUE

Permissions¶

Only a superuser can create a new database

create_database_statement ::=

    CREATE DATABASE database_name ;

database_name ::= identifier

Parameter	Description
`database_name`	The name of the database name. The database name must be unique, and follows Identifier rules

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

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