CREATE DATABASE: Creating a Database

Basic Syntax

CREATE DATABASE [IF NOT EXISTS] database_name [ON CLUSTER ClickHouse cluster name]

The syntax ON CLUSTER ClickHouse cluster name enables the Data Definition Language (DDL) statement to be executed on all instances in the cluster at a time. You can run the following statement to obtain the cluster name from the cluster field:

select cluster,shard_num,replica_num,host_name from system.clusters;

Example

• Create a database named test.

  CREATE DATABASE test ON CLUSTER default_cluster;

• After the creation is successful, run the query command for verification.

  show databases;
  ┌─name───┐
  │ default    │
  │ system     │
  │ test       │
  └──────┘