Skip to main content
Version: Stable-3.1

CREATE DATABASE

Description

This statement 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

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.

Examples

  1. Create the database db_test.

    CREATE DATABASE db_test;
  2. Create the cloud-native database cloud_db with the storage volume s3_storage_volume.

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

References