Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

create_* session settings

These settings are available in system.settings and are autogenerated from source.

create_if_not_exists

Type
Bool
Default
0
Version history
VersionDefault valueComment
24.90New setting.

Enable IF NOT EXISTS for CREATE statement by default. If either this setting or IF NOT EXISTS is specified and a table with the provided name already exists, no exception will be thrown.

create_index_ignore_unique

Type
Bool
Default
0

Ignore UNIQUE keyword in CREATE UNIQUE INDEX. Made for SQL compatibility tests.

create_replicated_merge_tree_fault_injection_probability

Type
Float
Default
0

The probability of a fault injection during table creation after creating metadata in ZooKeeper

create_table_empty_primary_key_by_default

Type
Bool
Default
1
Version history
VersionDefault valueComment
25.111Better usability

Allow to create *MergeTree tables with empty primary key when ORDER BY and PRIMARY KEY not specified

Navigation