Skip to main content
These settings configure the ClickHouse server and are autogenerated from ClickHouse source.

​
max_table_num_to_throw

If number of tables is greater than this value, server will throw an exception. The following tables are not counted:
  • view
  • remote
  • dictionary
  • system
Only counts tables for database engines:
  • Atomic
  • Ordinary
  • Replicated
  • Lazy
A value of 0 means no limitation.
Example

​
max_table_num_to_warn

If the number of attached tables exceeds the specified value, clickhouse server will add warning messages to system.warnings table. Example

​
max_table_size_to_drop

Restriction on deleting tables. If the size of a MergeTree table exceeds max_table_size_to_drop (in bytes), you can’t delete it using a DROP query or TRUNCATE query.
A value of 0 means that you can delete all tables without any restrictions.This setting does not require a restart of the ClickHouse server to apply. Another way to disable the restriction is to create the <clickhouse-path>/flags/force_drop_table file.
Example
Last modified on July 23, 2026