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

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.

   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

• SHOW CREATE DATABASE
• USE
• SHOW DATABASES
• DESC
• DROP DATABASE
• ALTER DATABASE