CREATE DATABASE

Purpose

You can use this statement to create a database and specify default attributes of the database, such as the default character set and collation of the database.

CREATE DATABASE is equivalent to CREATE SCHEMA.

Syntax

create_database_stmt:
    CREATE {DATABASE  SCHEMA} [IF NOT EXISTS] database_name [database_option_list]

database_option_list:
    database_option [database_option ...]

database_option:
    [DEFAULT] {CHARACTER SET  CHARSET} [=] charset_name
   [DEFAULT] COLLATE [=] collation_name
   REPLICA_NUM [=] int_num
   PRIMARY_ZONE [=] zone_name
   {READ ONLY  READ WRITE}
   DEFAULT TABLEGROUP [=] {NULL  table_group_name}

Parameters

Examples

• Create a database named test2 and specify the character set as UTF8.

  obclient> CREATE DATABASE test2 DEFAULT CHARACTER SET UTF8;
  Query OK, 1 row affected (0.00 sec)
  

• Create a database named test3 that supports read and write operations.

  obclient> CREATE DATABASE test3 READ WRITE;
  Query OK, 1 row affected (0.03 sec)