v.23.11New Feature

Add CHECK ALL TABLES query

Official CH changelog text
Add CHECK ALL TABLES query. #56022 (vdimir).
Introduces the CHECK ALL TABLES query in ClickHouse to verify the integrity of all tables in the database.

Why it matters

This feature provides a convenient way to perform integrity checks across all tables, helping users identify and address potential data corruption or structural issues in a single command, improving database reliability and maintenance efficiency.

How to use it

Execute the query:

CHECK ALL TABLES


This command will run integrity checks on every table in the current database without needing to specify each table individually.

Related resources

PreviousNext