ContextQMD
Back to Starrocks

CREATE DATABASE

docs/en/sql-reference/sql-statements/Database/CREATE_DATABASE.md

4.1.01.3 KB
Original Source

CREATE DATABASE

CREATE DATABASE is used to create databases.

:::tip

This operation requires the CREATE DATABASE privilege on the target catalog. You can follow the instructions in GRANT to grant this privilege.

:::

Syntax

sql
CREATE DATABASE [IF NOT EXISTS] <db_name>
[PROPERTIES ("key"="value", ...)]

Parameters

db_name: the name of the database to create. For the naming conventions, see System limits.

PROPERTIES (Optional)

storage_volume: Specifies the name of the storage volume that is used to store the database in a shared-data cluster. If not provided, the default storage volume will be attached to the database. The property can be changed via ALTER DATABASE statement.

Examples

  1. Create the database db_test.

    sql
    CREATE DATABASE db_test;

  2. Create the cloud-native database cloud_db with the storage volume s3_storage_volume.

    sql
    CREATE DATABASE cloud_db
PROPERTIES ("storage_volume"="s3_storage_volume");

References