Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

check_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

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

check_named_collection_dependencies

Type
Bool
Default
1
Version history
VersionDefault valueComment
26.21New setting to check if dropping a named collection would break dependent tables.

Check that DROP NAMED COLLECTION will not break tables that depend on it

check_query_single_value_result

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.120Changed setting to make CHECK TABLE more useful

Defines the level of detail for the CHECK TABLE query result for MergeTree family engines .

Possible values:

  • 0 — the query shows a check status for every individual data part of a table.
  • 1 — the query shows the general table check status.

check_referential_table_dependencies

Type
Bool
Default
0

Check that DDL query (such as DROP TABLE or RENAME) will not break referential dependencies

check_table_dependencies

Type
Bool
Default
1

Check that DDL query (such as DROP TABLE or RENAME) will not break dependencies

Navigation