These settings are available in system.settings and are autogenerated from source.
create_if_not_exists
Type
Bool
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.9 | 0 | New 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
| Version | Default value | Comment |
|---|---|---|
| 25.11 | 1 | Better usability |
Allow to create *MergeTree tables with empty primary key when ORDER BY and PRIMARY KEY not specified