CREATE DATABASE

May 28, 2026 · View on GitHub

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

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

Create the database db_test.
```
CREATE DATABASE db_test;
```
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

SHOW CREATE DATABASE
USE
SHOW DATABASES
DESC
DROP DATABASE
ALTER DATABASE